Thread: PIVOT TABLE formatting

Hi All,

I have a small formatting problem with a basic Pivot Table that I have created.

I have uploaded a sample file with dummy data.

I basically would like to show a subtotal for the 'calculated hours' column / field, at the bottom of each of the two Payroll weeks. It sounds very straightforward but I cant seem to find a way to do it.

Any help or advice much appreciated.

James

Thanks again DonkeyOTE,

The problem I have is that the real data I was using is so large, that when I add it to the data area, (and Excels default settings) it gives the error 'too many rows / columns.. more than 8,000 etc'. I worked around this by first limiting the Pivot table source data to only a small portion of the total, applying the format as desired (i.e. both calculated hours and payment amount in the data area, side by side columns) and then altering the wizard to include all data, which seems to work fine.

Another annoying problem workaround found!

Thanks