work with pivot table output
Posted on 2011-10-19
working with a list of net wages for the year and payments made, I get a list of over/underpayments on a line by line basis.
I have then used a pivot table to produce a total for the year for each employee.
I now want to strip out the December figure to see the result for the other 11 months separately.
I list the December figure in column D, all year figure in column C, I have tried to put a formula in Column E, but cannot copy the formula.
My question is how can I copy that 'formula' in column E down ? ( it works on a line by line basis, but that is too long winded.
NB whilst writing this qn, I realised I can do another Pivot Table on the 11 months data directly which will solve the problem (although trying to be careful about spreadsheet integrity, I like to add the individual numbers and thus check I get the same total by a different calculation, which I will not be able to do once I have a Pivot table as I have the same problem - I cannot 'manipulate' the output)