topic Custom Grand total issue in Pivot tables with Dynamic Data in Qlik NPrinting

Custom Grand total issue in Pivot tables with Dynamic Data

ranidas — Tue, 09 Aug 2022 17:15:22 GMT

Hi All,
I have a pivot table in QlikSense with 2 dimension(Country and City) and one measure with expression (A/B).
I have converted Pivot table to straight table and using Excel Pivot option for designing the structure w.r.tPivot table in QS, I Need to show Grand total in Pivot table in NPrinting , but its not matching with QS total which we enabled total feature from presentation tab. As per my analysis ,NP total simply doing the summation of final output (A/B) of measure values across each dimention values instead of calculating sum (A) and SUm (B) at overall level and doing the division .

To handle this , i have created variable with expression in QS for showing grand total by not using excels grand total , but since data is dynamic, i am unable to find the position for placing this and also we are dealing with 2 dimensions in pivot.

ISU	A	B	Exp in QS: A/B
QS Total	440	190	2.315789474	(Expected output)
A	100	20	5
B	140	70	2
C	200	100	2
		Grand Total in NP	9	(i.e 5+2+2)

Please help

@Lech_Miszkiewicz @Ruggero_Piccoli

Re: Custom Grand total issue in Pivot tables with Dynamic Data

Lech_Miszkiewicz — Wed, 10 Aug 2022 17:21:03 GMT

Well yes - you are correct - your total in NPrinting is summation as it is using excel pivot table features and you are limited to excel options there.

In those scenarios i tend to use workaround and depending on your final output requirements you may just mimic pivot table look using simply straight table data and grouping dimensions.

Re: Custom Grand total issue in Pivot tables with Dynamic Data

ranidas — Tue, 16 Aug 2022 06:39:14 GMT

Many Thanks for your inputs .