Expression depending on a field value

[Anonymous]

Hi, I have in a scatter chart a expressions as simple as this:

Sum(Data)

I also have a table (load inline) with 3 values: SalesAmount, Qty, CostAmount

I display this 3 values in a lis box.

My intention is that when I choose one of this value in the list box, the expression of the chart changes into somethig like this:

Sum(SalesAmount)

or

Sum(Qty)

or

Sum(CostAmount)

Any suggestions?

thanks

[rubenmarin · Accepted solution]

Hi, you can use conditional expressions, create 3 expressions, each one with a different condition, ie, supposing the inlite table field is called 'Metric':

Metric='SalesAmount'

Another option is create nested if expression:

If (Metric='SalesAmount', Sum(SalesAmount))

An another option is to use the value of the selected "Metric" as field name for the expression:

Sum($(=Metric))

[Anonymous]

Thanks Ruben, the Sum($(=Metric)) option works pretty weel to me.

[#4]

The Following will work

=sum($(=Only(Field)))

See attached example

[#5]

hi,

you can try enable condition

and write

if(metric='SalesAmount',1,0)

and then write your respected 

sum(SalesAmount)

with regards

harshita Gaur