Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Dimension for a line chart is YearMonth and the measure is Sum(Amount) . I have added 2 other dimensions Year and YearQuarter.
The requirement is when the user selects Year from the alternative dimension, the measure should be avg(Sales) and when he selects YearQuarter form the alternative dimension, line chart should dislay Sum({<Flag=1>}Sales).
Could anyone suggest what is the best way to achieve this?
Thanks in advance,
Anusha.
Create inline table for all this dimensions. Call this Field as Time.
Use Simple field select extension and add this dimension(Time) field to this dimension of Simple Field select.
Use Getfieldselection(Time) in dimension as well as Expression.
is there any way other than extensions?
Is there any way other than extensions?
I think this is the best way.
I tried using len function.
something like this.
if(len([YearMonth ]),
Sum(Amount),
if(len([Year]),
avg(Sales) ...