I was able to show the sum of profit by Quarter by adding a Reference line to the Pane level. As every pane represents a Quarter then Tableau aggregates the months together to get the value.
The steps are:
1- Go to the Analytics tab and drag a reference line over the Pane square that shows when you click on the reference line icon
2- Replace Average with Total for your aggregation
3- On Label pick the Value for the measure.
You should be done by then.
Attached the workbook with this solution.
I hope this helps
That's a nice tip, thanks for sharing.
However, it works for either quarter when i use quarter in my order date hierarchy or year when i use year in my order date hierarchy. Never for both since it is on pane selection. I tried table selection and that resulted in the sum of the entire data.
Can you help me focussing on quarter when quarter is selected and year when year is selected?