Create Grand Total Pivot Chart

Hi,

I have pivot table with two types of Revenue (Corporate A & Corporate B) in the column labels, and January to May in the row labels. These two types of revenue are chosen from a manual filter in the column labels as they form part of a general "Income" that is put in the column labels Pivot table field list.

Turning on grand totals in the the pivot table adds these revenues together. When creating a pivot line chart, the chart produces two lines (corporate A & corporate B) as expected. However, i just want to see a line for the grand total of A & B added together. Is this possible?

I can't create a calculated field as i can't choose to add corporate A and B together, only "income" which is the general type.

I hope I've explained this clearly!

Moggzzz

Pivot charts won't plot grand totals, but you can use a stacked line chart so the top line is effectively showing you the grand totals.