I am new to Pivot tables and I have watched an online video and it "looks" easy but I am struggling to get one to work for the attached file.
I am concerned that maybe what I am trying to do is too complex, meaning, that a Pivot table cannot work on this size of a table?
My goal is to be able to do two things.
a) Calculate monthly revenues and costs relating to these specific staff, by person name and by Position, eg Partners, Counsel, Associates etc. for each cost item, eg monthly salary, health insurance, taxes etc
b) the attached assumes some staff may join in the future, can a pivot table work this way? That i can add in names and new staff terms and will the pivot table auto update?
Thanks for advice on how best to structure this for pivots to work and make it easier to process the data quickly rather than manual excel?
Bookmarks