Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a issue to display cumulative sum in pivot table.Now am using the expression as
if(dimensionality()=0,0,RangeSum(Above(TOTAL Column(1),0,NoOfRows(TOTAL)))).
Iam not getting the Total Value for columnname Cumulative in the attached pivot table.So,Kindly all help me to solve this issue.
Thanks & Regards
Kartheesan
In your expression, you are explicitely returning 0 for your total line (dimensionality() = 0).
Instead, try using a sum-of-rows-in-pivot-table expression (check the HELP for more details, there is a whole chapter that covers that).
It would probably look similar to
if(dimensionality()=0,
sum( aggr( YOUREXPRESSIONCOLUMN1, Location, Month) )
RangeSum(Above(TOTAL Column(1),0,NoOfRows(TOTAL)))
)
where you need to replace YOUREXPRESSIONCOLUMN1 with the appropriate expression and double check your aggr() dimension field names.
Hi,
It works fine.The third dimension dragged into vertically alignment.The cumulative total gives correct result.Incase the third dimension dragged into horizontal alignment.The total become 0.
Thanks & Regards
Kartheesan