7 Replies Latest reply: Jun 13, 2016 6:37 AM by Umamaheswara Reddy RSS

    Help me to get only last 3 months data dynamically

    Umamaheswara Reddy

      HHi all

      i I have 2015 (Oct,Nov,Dec) and 2016(Jan,Feb) data, so I need to display only last 3 months data (Dec 2015, Jan 2016, Feb 2016).

      I tried with set analysis by using below mentioned expression

      Sum({1<Month={">=$(=MaxString(Month) -2) <=$(=MaxString(Month))"}>Sales)

       

      but the above condition fetch the data only 2015 only.

       

      HHelp me to solve

       

       

      THanks

      AR UMAMAHESH