sum of rows in pivot table

[#1]

Hi all!

I have a Pivot Table with 6 dimensions, not expanded, and I want to show total rows for each dim.

My expression must be evaluated with aggr function, because I do not want the expression for total but the real sum of rows.

It runs well with a single dimension.

I know I could solve the problem with a cyclic or drill down group, but pivot table expandable is required.

Any suggestion?

Thanks a lot!

[#2]

Hi,

i'm not really aware what your trying to calculate.

Maybe here an idea: try (SUM(TOTAL <[Your Dimension Field]> [ValuetoSum]))

Regards

Michael