2 Replies Latest reply on Nov 15, 2012 8:10 PM by Viswanath Sankar

    Previous member of a filter

    Viswanath Sankar

      Hi,

       

      I have a filter with a date field. I need to create a calculation to show the value of my measure (sales) for the previous member of the selected value. i.e. if I select Nov 2012 in the quick filter, the calculation needs to show me the measure value (sales) of Oct 2012. Could you please let me know how this can be achieved?

       

      Thanks

      Vishy