2 Replies Latest reply on Feb 21, 2017 7:44 AM by Vishal D

    Exclude current month data in level of detail expression

    Vishal D

      I want to plot last 36 months but in a calculated field I want to exclude current month.

       

      In attached twbx I am calculating MAX() over last 36 months but I want to exclude the current month numbers from it. So technically MAX over 35 months(not considering 35 months)

      I cannot simply edit the filter and make is last 35 months as I have to plot 36 months on graph. But only in the calculated field I have to consider only 35 months of data.

       

      Calculated field Name = MAX Monthly BPD

       

      How do I achieve this?

       

      Attached twbx in 10.0

       

      P.S : In attached twbx there is no data for Feb 2017 but in my production system I will have.