above rows total problem in pivot table

[#1]

hi,

[sunny_talwar]

Would you be able to share a sample to look at this issue?

[sunny_talwar]

Not sure, but seems like some sort of bug to me where when the 'Suppress Zero Value' is checked, the expression is double counting within RangeSum

[#4]

hi,

1.  can't replace column(1) and column(2) with actual expression because it's a big formula and if replace also it will give      calculate in different way.

2. the problem which you identified is same which i found range sum is calculating wrongly when suppress zero values selected. so am looking is there any different way available to add /sum up the resulted above rows instead of putting column(3) or rangesum or above or expression.

Thanks

[sunny_talwar]

There is another way, but that would still require you to use actual expressions instead of Column labels. One idea/suggestion would be to store your expressions within variables and then call them in your expression