Totals in Pivot Chart -finding a workaround

Hi everyone

I've got a number of pivot charts which I have been asked to add totals into.

It is monitoring number of requests for shifts in healthcare, comparing bank (in house) to agency (external).

The bosses want to see the combined total on the line graph I've produced, as well as the separate figures.



I can't seem to find a definitive answer on how to achieve this... I can't just turn it into a regular graph as it still requires the drop-down menu functionality to compare different hospitals etc.

The pivot table is constructed using COUNT of a field called Total Hours, to see how many individual shift requests there were per date. Each of these shifts is either BANK or AGENCY in one of the columns.


I think the key would be to somehow add another column in the raw data and process that somehow so as to be able to include the sum in the pivot? But I can't think how to do it :S


Any help greatly appreciated guys

Hi teylyn/everyone

Sorry to only just reply, I was on leave.

I've bodged together a sample database exactly the same as the one I use.


So in the context of the sample graph - i want to add a 3rd line, which is a summation of the other two.

Hope that is clear!

Thanks Romperstomper, I had a go at that, but these people are rather particular and will want 3 separate lines specifically...

I suspect that a column must be added in the raw data, I tried one with just a code in it (common to all rows) hoping that would act as a marker for counting all the rows, but this did not work - due to the pivot table layout this just duplicated the data