6 Replies Latest reply: May 11, 2012 11:25 AM by sandeepa rout

# How to show difference in pivot table

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...!!

• ###### Re: How to show difference in pivot table

Anyone??

• ###### Re: How to show difference in pivot table

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

-62-62=-124 only.

• ###### Re: How to show difference in pivot table

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.

• ###### Re: How to show difference in pivot table

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

-62+(-62)

= -62-62

=-124

• ###### Re: How to show difference in pivot table

It might be easier to just use 3 expressions.

• ###### Re: How to show difference in pivot table

Yeah, it works..!

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