Sum of rows in Pivot Table

[Anonymous]

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

[amit_saini]

Abhinav,

Change your expression to something like:

=Sum(Aggr(sum(AmtField) , Dimension))

Thanks,

AS

[Siva_Sankar]

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, ..))

[Anonymous]

I am Using the following expression:--

=sum(aggr(max({<STA = {'S'}, TYPE={'Sp1'}>}Order),D1,D2,D3,D4,D5)))/100