6 Replies Latest reply on Sep 22, 2016 4:24 PM by Shesil Parmar

    Last 3,6 and 12 months using parameter

    Shesil Parmar

      sorry guys if this has been asked before, i have had look but couldn't find exactly what i was after.

       

      so i need to navigate data using parameter; so i have managed to work out somewhat but i believe there should be some proper way to do this.

      so in my workbook, when someone select last 3 months and then it should show current month - last 3 months (ie someone using report in Sep then last 3 months will be June, July and August , same with 6 and 12 months) so basically it should not include the current month.

      but my calculation count month from current month, couldn't work it out.

       

      and need another paramater or option when selected last 3 months (ie someone using report in Sep then last 3 months will be July, Aug and Sept, same with 6 and 12 months) so little different than above,

       

      please see attached sample workbook.