12 Replies Latest reply: Sep 29, 2014 1:10 PM by Jyothish KC

# how to variable name to Diffrence

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

• ###### Re: how to variable name to Diffrence

Hi

Take A and B as Dimensions.

Hope this helps.

Regards,
Manideep

• ###### Re: how to variable name to Diffrence

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.

• ###### Re: how to variable name to Diffrence

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.

• ###### Re: how to variable name to Diffrence

RangeSum will work.

Thanks!

• ###### Re: how to variable name to Diffrence

Hi.

write third expression as

Sum(A)-Sum(B)

or

Column(1)-column(2)

Regards

ASHFAQ

• ###### Re: how to variable name to Diffrence

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

• ###### Re: how to variable name to Diffrence

Please send the code I am working on Personal Edition

• ###### Re: how to variable name to Diffrence

Thanks Freinds

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

Thanks

Pavan

• ###### Re: how to variable name to Diffrence

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

• ###### Re: how to variable name to Diffrence

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

• ###### Re: how to variable name to Diffrence

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??/?

• ###### Re: Re: how to variable name to Diffrence

Hi,

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

Var

col2-col1

In straight chart call:

\$(Var)

You will get what you want.

Regards

KC