4 Replies Latest reply on Oct 29, 2018 11:49 PM by cmelan Melan

    YTD Month filter for act vs. plan comparision

    cmelan Melan

      So I have actual values and plan/target values for my Sales measure.  I have plan for the full year, however I have actual data only until august:

      Just like here:

       

      I want to compare ACT vs. Plan, I only want date to be filtered by month according to the last value of actual (i.e. January-August.) How do I add a dynamic month filter that changes when new act are loaded (i.e. when September is loaded month range filter will be January-Sept?)