Pivot Table Row Totals - Excel 2010

[PWD]

Good morning, I'm sure that this has been asked a thousand times by a thousand people but I find it extremely frustrating, as well as baffling, that my Pivot Table won't give me Row Totals even with the appropriate options ticked.

My data consists of hospital specialties and the time patients have been waiting for their appointments - in weekly bands, i.e. "0-1", "1-2", "2-3" etc. The Pivot Table has the specialties as the Row Labels and the Values in each Column are the Sum of the weekly waiting bands. I know I can just add a SUM formula in the column to the right of the Pivot Table, but it just doesn't seem right.

I did read a tip about putting one of the column headings into the row labels and then dragging the literal "Data" to the right. I couldn't get this to do anything other than delete all the Columns and data.

It's probably not a show-stopper - just annoying that I'd have to do this with every Pivot Table I created from the original data source for my weekly reports.

Many thanks,
D€$

 

[SkipVought]

hi,

PivotTable Tools > Analyze TAB > PivotTable > Options > Options > Totals & Filters > Grand Totals

But it appears to me that you're doing this for each weekly workbook you're opening. Why not a macro for setup? Another possibility is to IMPORT your weekly workbooks into a MASTER, where everything is already formatted and structured to do the job, AND you get the opportunity to build monthly/quarterly/annual data, can compare data from previous years to this year etc. I often did this when it made sense.

 

[PWD]

High Skip, yeah all turned on. It seems to be a common thing 'out there'. I guess that I'll probably be dumping the weekly data into the same "template" workbook(s) every week and Saving As so once I've formatted each report - there will be different ones for the mandatory Government reporting cycle - then it's pretty much done. Thanks for your input.

Many thanks,
D€$