G
Guest
Excel 2003
I have following information in columns: Name, arrival date, departure date,
cost.
I would like to create a pivot table showing total headcount and cost on a
monthly level for the year in question and also on a yearly level for the
duration of the project. Presently I have an own row per person per month,
but I would like come up with something more sensible.
What would be an efficient way of handling this?
I have following information in columns: Name, arrival date, departure date,
cost.
I would like to create a pivot table showing total headcount and cost on a
monthly level for the year in question and also on a yearly level for the
duration of the project. Presently I have an own row per person per month,
but I would like come up with something more sensible.
What would be an efficient way of handling this?