7 Replies Latest reply on Oct 9, 2018 3:10 PM by NAYANA MADHEKAR

    Add Last Week Sales, Current month to Date Sales, & Quarterly Sales on one Sheet/View (For Dynamic Dates)

    NAYANA MADHEKAR

      Hi I have sales for different Markets A, B & C. And sales for them respectively on specific dates.

       

      I could easily have sales for current week, present month (Week ending dates of current month) & Quarterly (specific dates) on different sheets using filters.

       

      But I wish to have them on a specific dashboard, with no use of filters as the report is suppose to be dynamic.

       

      Can you please help with a way to do this? Would parameters help? What function would help?

       

      PFA.