Adding Grand Total to a pivotchart

[Zorkmid]

Hi all,


Im creating a series of charts to shows trends over time. I would like to include a "grand total" of records series to go in my line chart, and I can't seem to find a way to include it. All I can get is the individual column fields. If I leave the column fields blank, I can get the total, but not once I try and add filters.

What can I try?

 

[Zorkmid]

Maybe this will explain it a bit better.

I have a pivotable that shows me the counts of records that fall under a few degrees on injury. None, N/A, Slight etc.

I want to, on a pivotchart, show a line graph that displays serious, moderate, and grand total.

I can't seem to find a way to get the grandtotal column into the pivotchart view.