Hello Excellers,

I have a problem. I have a pivot table which summarises a causal factor and totalling up over months. I need to create a PIE chart from this data but need to use the grand total for the chart as for some reports I will include just current month data, for others, last quarter data and for others whole year data. Ideally I'd like to be able to do this by filtering the necessary months on the table / chart, but I can't find a way to use the table generated Grand Total column in the chart.

Is there a way to do this ?


Thank You!