Hello,
I try to count the number of sales order items based on a filter on headers.
I manage to do that:
SUM(CASE
WHEN VBAK.BSARK NOT IN (ZWEB, DFUE, ZMYP, ZMWS, ZTEL, ZPBI)
AND VBAK.ERNAM NOT IN (BZTLK, BTS16)
AND VBAK.VBTYP = C
THEN 1
ELSE 0
END)
But it only counts sales orders and not sales order items.
Note that I manage to do it with a Pivot Table (since we can choose on KPI to count VBAP or VBAK) but I also want to have percentages on the same OLAP table.
Thank you in advance
Antoine
