1 Reply Latest reply on Jun 25, 2019 2:38 PM by Mavis Liu

    Date filters and calculations

    Ramakrishna Rallapalli

      Hi,

       

      I have data from multiple years.  I would like to show the data YTD based on the Date (Single value drop down)  and years (Multiple values drop down) 

       

      If i select the date, for example 10th January and years 2016,2017,2018 and 2019 the report should show upto 10th Jan for all the years.

      If i select the date, for example 20th March and years 2016,2017,2018 and 2019 the report should show upto 20th March for all the years.(based on the date, the results should appear upto that date (Jan -20th March) for the years)

      If i select the date, for example 30th November and years 2016,2017,2018 and 2019 the report should show upto 30th November for all the years.(based on the date, the results should appear upto that date (Jan - 30th November) for the years)

       

       

      For example :  Filters  Year : 2016,2017,2018,2019

                                          Date :  Jan 10

                                          

      Day of Date       2016      201720182019
      JanuaryJanuaryJanuaryJanuary
      1469,298336,000526,44665,820
      2335,618622,929342,94845,000
      3289,437649,665322,16660,055
      4564,906567,272553,77261,684
      5650,000574,178510,663583,156
      6851,525826,209410,842267,478
      7333,786612,930575,358355,481
      8299,075624,426406,892578,989
      91,000,000493,934444,482402,723
      10693,379584,451382,9121,339,271
      Grand Total5,487,0245,891,9924,476,4813,759,657

       

      For example :  Filters  Year : 2016,2017,2018,2019

                                          Date :  Jan 03

        

      Day of Date        2016     201720182019
      JanuaryJanuaryJanuaryJanuary
      1469,298336,000526,44665,820
      2335,618622,929342,94845,000
      3289,437649,665322,16660,055
      Grand Total1,094,3531,608,5931,191,560170,875

       

      Is it possible?  Appreciate your help please.