Partial sum wrong

srishsum2017 · ‎2017-09-25

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

Sumit Kumar Srivastava

kaushiknsolanki · ‎2017-09-25

Hi,

Try this expression.

Sum(Aggr(Count(Quantities),Zone,SalesOffice,Product,Dealer))

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

srishsum2017 · ‎2017-09-25

I tried this but its not working

Sumit Kumar Srivastava

kaushiknsolanki · ‎2017-09-25

It should work. If possible share sample data.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

its_anandrjs · ‎2017-09-25

Share some data or do you have any blank zones there or may be use Sum of Rows in the chart properties.

mdmukramali · ‎2017-09-25

Dear,

Attach the sample Data.

Related Topics