1 Reply Latest reply on Nov 30, 2018 3:24 AM by Sunitha Nagalapur

    how to plot single measure for varying date column based on condition derived from single date column

    Sunitha Nagalapur

      Hi  All,

       

      I have one measure(Fcst $PU) ,one date column (ARCHMMYY’) I have to plot 'forecasted cost per unit' using date column in single worksheet. Please suggest below mentioned are the details.

       

      • Actual is measure (ie.. Fcst $PU – forecasted cost per unit ) - No selection of date will be provided for user
      • Month One: an ‘ARCHMMYY’ month selected by the user
      • Month Two: an ‘ARCHMMYY’ month selected by the user, should be > Month One   ( ie..Month one+one month)