Forum Discussion

tylesftw's avatar
tylesftw
Icon for Helper II rankHelper II
6 years ago

Cumulative Sales - Getting the Sales Line to Stop

Hi All,   I've been given a dataset that has both Sales & Forecast in one dataset. This means that the below code does not work as it extends out the sales line to match the FY2020 months. Without ...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi tylesftw ,

 

What's your Axis column?

Try create a measure like

If(selectedvalue(axis column)<=maxx(all(table),reportdate),1,0)

Then add the measure to visual filter measure is 1.

 

Best Regards,

Jay

 

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi tylesftw ,

 

Have your problem be solved?

  • tylesftw's avatar
    tylesftw
    Icon for Helper II rankHelper II
    6 years ago

    I've parked it for the moment.. thanks for your help all