topic Re: Pivot table with subtotals in QlikView

Pivot table with subtotals

keitel2015 — Sat, 16 Nov 2024 02:27:14 GMT

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!

Re: Pivot table with subtotals

marcus_sommer — Wed, 18 Sep 2019 12:02:06 GMT

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

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

- Marcus

Re: Pivot table with subtotals

keitel2015 — Mon, 23 Sep 2019 08:17:05 GMT

Thanks!