1 of 1 people found this helpful
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.
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?
You can select the second "Quarter" from the drop down and the change it to Discrete.
You can click on the SUM(Sales) and go to Quick table calculation and select Differences.
SUM(Sales) > Quick table calculation > Differences