Results 1 to 2 of 2

Thread: % of Group

  1. #1
    Join Date
    Mar 2005

    Exclamation Unanswered: % of Group

    In a pivot table is there anyway you can get the percentage by Group for instance

    Admin 1
    Site 1
    Site 2
    Site 3
    Admin 2
    Site 1
    Site 2
    Site 3
    Admin Total

    repeat above groupin but for consultants

    I want it so that next to each site i have the value and also the % value of that amount in relation to total Admin cost
    Last edited by Databaseman; 08-26-08 at 00:55.

  2. #2
    Join Date
    Oct 2003
    Howdy. Yes, that can be done, but it takes a little to do this and moving elements around. Will you be doing this frequently? The reason I ask is that this can be done much more efficiently using VBA to construct the Pivot tables, and then you have much greater flexibility in working with the data as well as formatting. And if changes need to be made, they can be made faster using this approach. Check out Chapter 12 of the book VBA and Macros for MS Excel by Bill Jelen (Mr Excel) and Tracy Syrstad. Superb book, and they give actual code to accomplish most of the difficult work.
    old, slow, and confused
    but at least I'm inconsistent!

    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts