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?
