Pivot Sub Total and Grand Total are not matching Why... ?

[Srinivas]

Hi All,

I have grouping dimensions like five groups below screenshot way

but each group have 20 to 25 dimension, Here i am did sub total for all groups, All sub totals values and Grand total values are different,

Why it is happen any idea please give me suggestion ASAP.

Advance Thanks,

Munna

[swuehl]

It's hard to tell from the information provided.

Please note that subtotals in pivot tables are evaluated using expression total mode, not sum-of-rows.

If you need sum-of-rows, you can use advanced aggregation like

=Sum( Aggr( YourExpression, DimensionField1, DimensionField2))

[Srinivas]

Thanks Swuehl for quick reply,

I have this idea but,I have around 25 dimensions, So could you please any another option that would be better.

Advance Thanks,

Munna

[jonathandienst]

You need something like this for cyclic dimensions in an aggr()

=Sum( Aggr( YourExpression, $(=GetCurrentField(All_Options)) ))

=Sum( Aggr( YourExpression, $(=GetCurrentField(All_Options)), $(=GetCurrentField(All_Options2)) ))

(Note that getCurrentField() sometimes has a problem with cyclics with a space in the name)