Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
I am using a Pivot table with the dimension of zone, sales office, product and dealer and taking the count(Quantities), my data is coming correct but at zone level the partial sum comes wrong.
Please help me to solve this
Hi,
Try this expression.
Sum(Aggr(Count(Quantities),Zone,SalesOffice,Product,Dealer))
Regards,
Kaushik Solanki
I tried this but its not working
It should work. If possible share sample data.
Regards,
Kaushik Solanki
Share some data or do you have any blank zones there or may be use Sum of Rows in the chart properties.
Dear,
Attach the sample Data.