5 Replies Latest reply on Sep 26, 2018 1:24 AM by Kashish Bhola

# How to create a column to show the average of sales for each quarter along with the sum(sales) by Year, Quarter and months? Below I have an image of what is needed using sample super store data. Can anyone please help?

In this problem I need to show total sum of sales for all the Sub-Categories by Year, Quarter and Month. Along with it I want to see the quarterly average for each sub-category. I can create the average in a separate sheet and bring them together in the dashboard (may not be the best solution) but how to show that in the same sheet?

• ###### 1. Re: How to create a column to show the average of sales for each quarter along with the sum(sales) by Year, Quarter and months? Below I have an image of what is needed using sample super store data. Can anyone please help?

Hi Unmesh

You seem to have provided a picture in your excel document. In future it would be best to copy and paste the data directly.

(EDIT: Sorry, din't realise that was the sample super store data)

You can get the totals in the analytic pane on the left hand side, that might solve the problem.

Kind regards

Gheorghie

1 of 1 people found this helpful
• ###### 2. Re: How to create a column to show the average of sales for each quarter along with the sum(sales) by Year, Quarter and months? Below I have an image of what is needed using sample super store data. Can anyone please help?

Hi Gheogrie,

Now can we use the Quarterly averages to calculate the difference between each quarter in the same view like Q2 - Q1, Q3 - Q2 and Q4 - Q3 and show the results?

Thanks,

Unmesh

• ###### 3. Re: How to create a column to show the average of sales for each quarter along with the sum(sales) by Year, Quarter and months? Below I have an image of what is needed using sample super store data. Can anyone please help?

Hi Gheorghie,

I wanted to ask how did you Merged ''2017 Q1'' ?

Regards

Kashish Bhola

• ###### 4. Re: How to create a column to show the average of sales for each quarter along with the sum(sales) by Year, Quarter and months? Below I have an image of what is needed using sample super store data. Can anyone please help?

Hi Kashish

You can select the second "Quarter" from the drop down and the change it to Discrete.

Thanks,

Unmesh

• ###### 5. Re: How to create a column to show the average of sales for each quarter along with the sum(sales) by Year, Quarter and months? Below I have an image of what is needed using sample super store data. Can anyone please help?

Hi Unmesh,

You can click on the SUM(Sales) and go to Quick table calculation and select Differences.

SUM(Sales) > Quick table calculation > Differences

Regards

Kashish