Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am using an Expression in Straight Table and getting result using sum of rows option under expressions tab. I've used the same expression in pivot table, but I am getting wrong values at subtotal level. I am trying to achieve sum of rows through aggr() function.
Please tell me how to achieve sum of rows in pivot table.
Abhinav Pandey
Abhinav,
Change your expression to something like:
=Sum(Aggr(sum(AmtField) , Dimension))
Thanks,
AS
In a pivot table chart your total is evaluated as expression total. You will noticed that the Total Mode option is disabled in expression tab for a pivot.
Solution: Try checking the Help for sum of rows in pivot tables.
Eg:
sum(aggr( YOURXPRESSION , DIM1, DIM2, DIM3, ..))
I am Using the following expression:--
=sum(aggr(max({<STA = {'S'}, TYPE={'Sp1'}>}Order),D1,D2,D3,D4,D5)))/100