• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pivot Table - Population Min/Max displayed on same table as Sub-Group

C

chilling

New Member
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 sites
        Max Rate for Role across all sites

      Min Rate for all sites
      Avg Rate for all sites
      Max Rate for all sites

I still want to show the Min/Avg/Max figures when a single site is chosen so that I can print out a report showing the site manager how much he is paying his staff compared to the other sites within the group.
 
Yes - but new to the forum so will take a little time to find my way around .... as you will have noted with my multiple edits to sort out the semi-html formatting of lists!
 
You can upload it to any free file hosting website and copy/paste the link here so that any one can access it..Hopefully your problem will be resolved very soon.. Every one has been new at this forum (at least once for sure) so no need to worry about that :)
 
Uploaded spreadsheet with sample data to:

https://skydrive.live.com/redir.aspx?cid=688452f3821ab84d&resid=688452F3821AB84D!141&parid=root


On summary two pivot table which I would ideally like to show as a single table


This spreadsheet was created in Excel 2003
 
Hi Chilling,


See this file, The Annual FTE is already present in your first table, The Hourly FTE has been added, hopefully will serve your purpose:


http://dl.dropbox.com/u/60644346/Copy%20of%20120229%20Staff%20Salaries%20120315%20no%20names.xlsx
 
No what I am after within each Role:

- Name

-- hourly

-- FTE annual

after all the names for that role

- Avg for that role for site (ie group SubTotal - but average)

- Min/Avg/Max for that role for the group (ie Group Total including Sites which are not displayed)
 
Sorry - I was using the generic term "Site" for the forum, our sites are call "Practices" as each site is a different dental practice.
 
No Problem, Lets take example of hygenist:

[pre]
Code: 
Hygienist	Staff name 14	Hourly	         27.50
FTE Annual	 53,625.00
Staff name 15	Hourly	         23.51
FTE Annual	 45,849.48
Hygienist Hourly			         25.51
Hygienist FTE Annual			         49,737.24
[/pre]

The Last two lines are showing averages for Hourly and FTE Annual. Do you want to show Max and Min for that as well? Kindly check out the link in my last post I have modified the file.


Faseeh
 
You must log in or register to reply here.
Back
Top