5 Replies Latest reply on Jan 4, 2019 3:48 AM by Zhouyi Zhang

    Current month and YTD Sales

    chowdary v

      Hi All,

       

      I have data from January to December.

      I want to show current month and YTD sales in same sheet.

      eg:

      i selected feb in filter it show feb sale and YTD = Jan+ feb sales in single view

      i selected mar in filter it show mar sale and YTD = Jan+ feb + mar sales in single view

      i selected apr in filter it show apr sale and YTD = Jan+ feb + mar + apr sales in single view

      etc...

      i create one parameter and i write below logic i got output like that only

      i want to show apr and YTD = Jan+ feb + mar + apr

      but it's show apr and YTD = Jan+ feb + mar only

      date int is parameter

      how can i do this please help me out

      thanks,

      chowdary