Show total for pie chart from a pivot table in title

Hi,

I have a pivot chart that is a pie chart from a pivot table that has sums of multiple fields. So, I want to be able to put the total either in the title after the name or somewhere in the chart.

For example, I have the names in the column (6 names so 6 columns). The rows for my pivot table are the sum of each source (15 rows total). I created a filter using another pivot chart and slicers to filter by name. So when I choose a name, I see in my pie chart the number of each source. So, say I filter for John Smith. The pie chart will only show John Smith and only the sum of the sources under him. So lets say, website is 7 and board is 3 and search is 5. I want the total (15) to show up on the pie chart either in the title after the name (John Smith - 15) or somewhere on the chart.

Sorry for the terribly long explanation. I am not even sure if this is possible for a pivot chart.

As always, your help and suggestions are greatly appreciated.

Thank you!

Thank you for your help.

In addition to your answer, if the grand total cell is calculated in the pivot table, you cannot reference that cell. To reference the grand total, I had to click on the cell below it, then make that cell = the grand total cell (=GETPIVOTDATA("Sum of #",$F$2)). Then I did your method using this cell (F22).