Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
What is the dimension name and what is the group name?
try using if GetCurrentSelections function
example
=if(GetCurrentSelections([dimesnion],'value),
//IF TRUE
sum(field),
//IF FALSE
count(field)
)
did you try GetCurrentField
e.g.
if(GetCurrentField(TestCylc)='Dim1', expression1, expresion2)