Pie Chart

[yisfromer]

Hi,

I have a pivot table of all expenses in rows and months (Jan 2012-Jan 2014) in columns

I would like to create a pie chart showing the percentage each expense is of the total expenses. The problem:

I would like to be able to filter the pie-data so that I can see the percentages of the sum of the selected months. For instance, I want to be able to choose to filter to show only June-August 2013 and see a pie chart reflecting percentages based on the SUM of each expense for the months of June-August 2013.

Is this possible? How? (perhaps some way I can use the timeline filter for this?)

Thank you so much!!!

 

[yisfromer]

Does anyone have a solution please? Does anyone need clarification? Thank you so much!