• 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.

Search results

  1. C

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

    Sorry - I was using the generic term "Site" for the forum, our sites are call "Practices" as each site is a different dental practice.
  2. C

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

    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)
  3. C

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

    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
  4. C

    Pivot Table - Population Min/Max displayed on same table as Sub-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!
  5. C

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

    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...
  6. C

    Hello .. Introduce yourself

    Hi, I am Chris in the UK, very long time user of Excel (ie from first launch) as a convertee from Lotus 123. A sometimes very frustrated user, because I know it can be done but struggle to find an elegant solution! I am looking forward to finding those solutions with your help and helping...
Back
Top