Hi everyone

I know this has been covered a lot before, but i've got a lovely pivot table with two fields under rows, dates in the column and a single financial field in the values. The pivot shows subtotals of one of the row fields.
I want to create a pie chart which just shows the subtotals.
When I create the pie from the pivot, naturally excel shoe-horns the entire pivot data into the chart and doesn't allow you to do much with it.

Besides creating my own chart and selecting the totals individually, I would prefer to use the pivot pie if possible so my slicers work dynamically with the visualisation.