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

[jyothish8807]

You can get the different simply by creating a third exp"

Sum(A)-aum(B).

There is no need to create a variable for that.

If you try to crate a variable then it will not get asociated with the staright chat you will use.

You can try by calling the variable in a text box,it will give the right output according to your selection but will gice the grand total difference in a staright chard.

Regards

KC

[#3]

Thanks Jyothish

MY problem is if the user clicks on diffirence value another piovt chart shoud appear with current selections.

For that I want to create a variable for the diffrence. Based on the variable I will give conditional show to second pivot chat. Is there any other way??/?

[jyothish8807]

Hi,

PFA. In variable write:(Don't put = sign)

Var

col2-col1

*corresponding field in your case

In straight chart call:

$(Var)

You will get what you want.

Regards

KC