2 Replies Latest reply on Feb 12, 2019 10:33 AM by Monisha Ramesh

    Calculate % difference between 2 sheets which each use Relative Date

    Monisha Ramesh

      I have a dashboard where I use 2 sheets having the same values but differ in the Relative date filter used for each sheet. I need a new sheet to calculate the percent difference between the two.

       

      The reason why I can't keep both bars in the same sheet is that I need both bars to be filtered according to the Relative Date filter separately according to the users wish.

      I am not aware of any calculated field I could use which could understand to calculate the value according to the relative date for that sheet .. please help!