2 Replies Latest reply on Feb 3, 2019 6:05 PM by Prakash Desai

    Selected time period vs previous time period without parameter

    Prakash Desai

      Hello,

       

      I got struck with one of the issue i.e displaying current sales along with the previous time period sales dynamically in the same sheet without parameter for the selected time period

       

      Req is to have both Current & Previous in the same sheet, if not 2 sheets and should not hard code any time period and should support for new refresh/time period. Please let me know for any work around.

       

      If Time Period=2017-H1, then current sales will be displayed for 2017-H1 and previous sales is for 2016-H2 time period and so on..

       

      Thanks!