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

# Calculate the Sales Difference Between Year and Quarters

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

• ###### 1. Re: Calculate the Sales Difference Between Year and Quarters

Hi Anandh,

Your challenge is already stored in the following thread Calculate the Sales Difference Between Year and Quarters

Regards,

Norbert

• ###### 2. Re: Calculate the Sales Difference Between Year and Quarters

Hi,

If you look into the workbook the issue is different actually in the previous one filters same so we can do the calcualtion as you said. But in the attached new sheet you can for 2017 the values are same but 2018Q1 the values are different based on the filter selectiuon.

Now what i have to do here is ti want to subtract the blue marked 2018Q1 value with yellow marked 2017 values based on filters