2 Replies Latest reply on Dec 8, 2018 8:18 PM by Anandh V

    Calculate the Sales Difference Between Year and Quarters

    Anandh V

      If filters are different for the same scenario. then how it will work.

      Please look at the image below I have attached the workbook has 2 sheets one will filterd all values other with less values are filtered. In this how to do the same calcualtion.

          

      Your previous calculation is working fine but when the filters changed that time the values are differing.

       

      Example: in yellow marked you can see for 2017 value is 609206 and 2018Q1  value is 123145 with certain filter condition.

      the same for blue marked different filter condition but 2017 value is same but 2018Q1 value is different.

       

      I have atatched the workbook with two sheets filtered with different condition.

       

      Message was edited by: Anandh V