1 Reply Latest reply on Apr 16, 2018 10:47 AM by Patrick A Van Der Hyde

    Actual and Plan numbers dual line only for current quarter. Historical quarter should overlap.

    youthesh sagar

      Hi All,

       

       

      Need your help on a calculated field which i am currently stuck at.

       

       

      I have sample data with plan and actual numbers.

       

       

      My requirement is to show Actual and plan numbers separately for current quarter(Q2 2018).But historical quarters should show plan as actual as same numbers

      (Actual and plan numbers should overlap for historical quarters and show a single line chart as shown below)

       

       

      Desired Output:

       

       

       

       

      This calculation is not working for quarter_view but works for month_view. Please see the screenshot.

       

       

       

       

      Please help me by changing my logic without altering any other calculation

       

       

      Thank You