how to variable name to Diffrence

[#1]

Hi Friends,

I crated Pviot table with values Sum(A) adn Sum(B). I want to take diffrence between these two values.

I created a varibale vDiff=Sum(A)-Sum(B). Its giving me a total aggregation difference.

.

Please let me know how to only difference between Sum(A) and Sum(B) specific to that row only.

Thanks

[manideep78]

Hi

Take A and B as Dimensions.

Now add an expression RangeSum(A)-RangeSum(B)

Hope this helps.

Regards,
Manideep

[#3]

Hi,

Add one more expression in pivot table with Expression label1-Expression label 2.

which will be nothing but Sum(A) -Sum(B) specific to that row only.

[senpradip007]

Give names for Sum(A) and Sum(B), for example let say you give Sum(A) as colA and colB for Sum(B). Now you can write colA - colB and you will get your desire result.

[#5]

RangeSum will work.

Please see if that helps.

Thanks!

[ashfaq_haseeb]

Hi.

write third expression as 

Sum(A)-Sum(B)

or

Column(1)-column(2)

Regards

ASHFAQ

[anbu1984]

You can use labels assigned to Sum(A) and Sum(B). Check this

[#8]

Please send the code I am working on Personal Edition

[#9]

Thanks Freinds

But I want to assign a varibale to Sum(A)-Sum(B).

Thanks

Pavan

[anbu1984]

Do you want to store difference for any particular row in the variable? What is the condition to select that row?