Is it possible to show the following all on one Pivot Table:
Example:
We have a number of sites and I want to product a report on Staff salaries showing:
By Period
By Site
By Role
By Staff Name
- Rate
- Annual cost
Min Rate for Role across all sites
Avg Rate for Role across all...