Partial sum Of pivot table not correct

Mon, 20 May 2013 13:41:53 GMT

Hello,

I have pivot table with dimension 1)Segment 2) market segment 3)Group/Non-Group .

when we have two usd and kes currency.when we select usd then local sales Value converted in usd currency &

Export Sales value as it is.

When we take partial sum of market segment for both local & export it is showing incorrect total.ans also segment total is incorrect.

I have attached pivot table image pls find it below.

pls help out me in this.

Thanking u.

Re: Partial sum Of pivot table not correct

Mon, 20 May 2013 15:10:49 GMT

sum(aggr(sum(Value),Dimension1,Dimension2,Dimension3,Dimension4))

for the all three expressions