Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi
Take A and B as Dimensions.
Now add an expression RangeSum(A)-RangeSum(B)
Hope this helps.
Regards,
Manideep
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.
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.
RangeSum will work.
Please see if that helps.
Thanks!
Hi.
write third expression as
Sum(A)-Sum(B)
or
Column(1)-column(2)
Regards
ASHFAQ
You can use labels assigned to Sum(A) and Sum(B). Check this
Please send the code I am working on Personal Edition
Thanks Freinds
But I want to assign a varibale to Sum(A)-Sum(B).
Thanks
Pavan
Do you want to store difference for any particular row in the variable? What is the condition to select that row?