OK - now you are showing off!
I'm impressed (albeit unable to fully follow what you have done). Problem is that I'm not sure I can properly maintain this once handed over to users to break.
Jeffrey - yes, in this report I do not aggregate data - I use the table to apply calcs to the downloaded data before using the pt to select the relevant lines of data by job.
Thanks for your responses. I suspect the answer is No but worth asking. I have attached example of sheet - I have removed the ODBC links but essentially project info is sourced from Accounting system on 2nd and 3rd sheets then presented in Pivot Table on first.
Challenge is to then get...
Is there a way of appending a column to a pivot table which allows data to be typed in to it?
I am downloading a Job Costing ledger in to Excel and analysing project performance using pivot table. This makes it easier for non-users of our accounting system to see project performance. The no. of...