Your challenge is already stored in the following thread Calculate the Sales Difference Between Year and Quarters
Please close or remove this thread.
Your cooperation is appreciated.
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