5 Replies Latest reply on Dec 7, 2018 5:56 AM by Anandh V

# Calculate the Sales Difference Between Year and Quarters

Hi,

I have a scenario that i have a sales value for years 2015,2016,2017,2018Q1,2018Q2,2018Q3,2018Q4. Here i want find out the difference  of sales between 2017 with 2018Q1, 2017 with 2018Q2 likewise for all th 4qtrs in 2018.

Suppose sales of  2017=5000

for                     2018Q1=2000 so difference is 3000

like that 2018Q2=4000 then differecne is 1000

i want to calcualte all these difference of 2018 all the qtrs with previous years.

i have attached the sample excel calcualtion and workbook as well please help me to get this done.

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

Hi

Do you want to compare the WHOLE YEAR SALE OF 2017 with 2018 QUARTERS
or
Do you want to compare the 2017 QUARTER with 2018 QUARTERS

Thanks

1 of 1 people found this helpful
• ###### 2. Re: Calculate the Sales Difference Between Year and Quarters

Hi Anandh,

Find my approach as reference below and stored in attached workbook version 10.5 located in the original thread.

1. M1. Sales 17: {fixed:sum(IF ([Order Date (group)])='2017' THEN ([Sales]) END)}

2. M2. Sales 2018Q1: {fixed:sum(if [Order Date (group)]='2018Q1' then [Sales] END)}

3. M6. Delta 17 2018Q1: [M1. Sales 17]-([M2. Sales 2018Q1])

4. etc

Hope it helps

Regards,

Norbert

1 of 1 people found this helpful
• ###### 3. Re: Calculate the Sales Difference Between Year and Quarters

Hi Anandh,

you can achieve it by using table calculation. please find the attached sample twbx for more details.

Regards,

Anupam

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

You can use any one of approach table calculation vs LOD function what ever meets your requirements. Please find attach the workbook. It might help you.

Thanks,

Himanshu Goyal

1 of 1 people found this helpful
• ###### 5. Re: 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.