Pivot table with subtotals

[keitel2015]

Dear Community

I'm struggeling with one expression of my pivot table. I try to wrap up the total of a certain column in the middle of my pivot table (see screenshot below).

Expression, I'm using is:

=Bottom(TOTAL RangeSum( Above(TOTAL
(
[KPI 3]
)

, 0, NoOfRows())))

With the aforementioned expression, I get the totals of Product Group. If I change it to NoOfRows(TOTAL), I get the total of the entire pivot table. Any ideas?

Thanks in advance! 

[marcus_sommer · Accepted solution]

I think you don't need the interrecord functions - just try:

sum(TOTAL <[Product Segment]> [KPI 3])

- Marcus

[keitel2015]

Thanks!