Is it possible to get Pivot Table "Grand Total" into the pivot chart?

Hello everyone...

I need help. I need my chart to include the grand totals in a secondary axis (line chart)... but I can't seem to figure out how. I have enclosed a photo and a worksheet. Any help you could provide me would be greatly appreciated. Maybe I am taking the wrong approach to compiling this information. The Pivot Table has broken the data out correctly, I just cant get the totals on the chart.

12345.jpg

GTAVG.xlsx

Well, I have had no success figuring this one out using the pivot table... can someone assist me with creating the same table using a formula or function? I basically need the average by month and year per customer.


Average by month and year.xlsx