Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
sum(aggr(sum(Value),Dimension1,Dimension2,Dimension3,Dimension4))
for the all three expressions