Pivot Report help

arusanah — Tue, 19 May 2015 21:00:07 GMT

This is the out put from one of the pivot reports . My Requirement was to show Partial sum at Discount Product level . so in presentation level i checked the show Partial sum . But then it shows partial sum for PDG SAP column too . which is nothing but discounts being pulled from SAP.

Discount Product	PDG Code	Bucket Revenue	PDG SAP	PDG Qualify	PDG Difference
A	AA	185,756.10	-31.68%	-	-
A	AM	193,821.45	-30.30%	-	-
A	Total	379,577.55	-30.89%	-	-
B	AM	2,757,412.89	-23.19%	-	-
B	Total	2,757,412.89	-23.19%	-	-
C	BF	189.28	-27.50%	-	-
C	Total	189.28	-27.50%	-	-
D	BG	226,291.39	-19.32%	-	-
D	Total	226,291.39	-19.32%	-	-
E	AA	971,635.54	-25.92%	-	-
E	Total	971,635.54	-25.92%	-	-
F	AE	156,382.22	-24.96%	-	-
F	Total	156,382.22	-24.96%	-	-

G	AJ	159,928.27	-14.43%	-	-
G	AI	155,123.49	-14.89%	-	-
G	AL	390.72	-7.50%	-15.00%	7.50%
G	Total	315,442.48	-14.61%	-	-

if we take a closer look at total it averages out the PDG SAP Column. which we don't want . so is there a way we can leave this column without performing aggergation on it?

Re: Pivot Report help

swuehl — Tue, 19 May 2015 22:00:58 GMT

You can try dimensionality() function or for a pivoted column secondarydimensionality(), maybe like

=if(dimensionality()>1, YourExpression)

Replace YourExpression with the PDG SAP expression.

Re: Pivot Report help

arusanah — Wed, 20 May 2015 01:37:48 GMT

thanks Swuel!!!

topic Re: Pivot Report help in QlikView

Pivot Report help

Re: Pivot Report help

Re: Pivot Report help