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.
