Hello All,
I have created line chart with below scenario,
dimension: Week
Measure 1 : Sum(value)
Alternative Measure 2 (Past_10_weeks): SUM{<WeekID={">=$(=(Max(WeekID) -11))<=$(=(Max(WeekID)))"}>} Value)
I have included Median line for this chart using Measure1 expression, Now if i choose Alternative measure 2 , The median value is not changing, how to fix this for working with Alternative Measure 2.
Thanks in advance!