Change Chart Expression Depending on What Cyclic Dimension is selected

[prees959]

Hi,  I have a Cyclic Dimension in my chart,

At the moment the expression is Sum([Total Sales])

There is one Dimension that when selected I need to change the the Expression  to Count(Manufacturer)... is this possible?

Many Thanks,

Phil

[sunny_talwar]

What is the dimension name and what is the group name?

[Alaaaq]

try using if GetCurrentSelections function

example

=if(GetCurrentSelections([dimesnion],'value),

//IF TRUE

sum(field),

//IF FALSE

count(field)

)

[dplr-rn]

did you try GetCurrentField

e.g.

if(GetCurrentField(TestCylc)='Dim1', expression1, expresion2)