Expression to subtract rows in pivot table

[Anonymous]

Hello,

I would like to use an expression to subtract the value of one dimension from other to get the difference please.

So I would like to subtract the first product from the below product to get the difference in values.

Thanks,

Esther

[Anil_Babu_Samineni]

Try to use

Above(Sum(Sales))

[Anil_Babu_Samineni]

My intention is this?

Sum(Sales) - Above(Sum(Sales))

[sunny_talwar]

But what is the point of doing this? What is the final goal you are trying to achieve?

[Anonymous]

I need to find out the difference between the two values

[sunny_talwar]

I guess I understand, but what is the use of finding difference between different products across the whole chart where I am guessing you might have more than just 2 products?

[Anonymous]

Hello,

I just made up that example to find out what the correct expression was. I needed it for my summary table it will not be used to find the difference between several products.

[sunny_talwar]

So you have got what you wanted then?