How to show difference in pivot table

[#1]

Greeting All,

Please find the attached qvw file.

Please suggest how to calculate the difference where the value of IMS and IRR in -ve.

Thanks...!!

[#2]

Anyone??

[jagannalla]

What is the problem here. It is coming exactly right.

-62-62=-124 only.

[#4]

Thanks for responding..!!

It is -62- (-62)

=> -62+62

=>0

It implies the value of IMS = IRR , so the difference should be zero.

But it is not differentiating correctly on -ve values.

[jagannalla]

No no.. if you choose show paritial Sums it works like below

-62+(-62)

= -62-62

=-124

[#6]

It might be easier to just use 3 expressions.

[#7 · Accepted solution]

Yeah, it works..!

We also can use columnno() instead of dimensionality().