Additional Reports Structure

[mal.b.graham]

Hi there
After getting this trainng excel database up and running with over 2000 entries, I have now been asked to have additional reports for the morning that can show the following:-

Total Number of Training Completed by depot by individual by role, by year
Total Number of Training Outstanding by depot by individual by role, by year

I know that the best way forward with this is by pivot table but I having difficulty including this in the reports tab and to show the correct information..... any help / pointers / assistance gratefully appreciated

Thanks

[jpr73]

Hi,
May be with pivot table
See attached a proposal with 3 kinds of pivot table : general, hours and outcome
Note : in records sheet there is no data for Role field
Is that what you expect
Best regards

[mal.b.graham]

Hi
Maybe I didnt explian fully, I am trying to insert a new pivot table into the existing reports as below and i am stuck on the code see line starting csOutstandingTraining..............

Please Login or Register  to view this content.