Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Jul 2007
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel 2007 Pivot Custom %

    I have an excel pivot that I need to add a custom calculation. Below is the data:
    Hardware Virtual Total
    Community 167 65 232

    The field I need is the %Virtual of the total.
    I've tried many different scenerios with field settings, but I'm not coming up with the correct answer.
    The Total column is optional.
    Hardware and Virtual are part of the field = 'Tier'

    Thanks for your help!
    Last edited by flamingoparty; 2011-04-26 at 15:39. Reason: reformat data

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    You need to right-click, choose Field settings and choose to display as % of row. Note that this will affect all values on the row.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    New Lounger
    Join Date
    Jul 2007
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks Rory, that worked. But I have a more complex issue now. I've added a field to column labels, so now I need % of Virtuals for each Operating system for each hardware, Virtual grouping. So now the % of Row doesn't work.
    Any Ideas?
    Thanks,

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    I doubt you can do that in the table if I've understood the layout properly - a sample workbook (dummy data is best) would help to be sure.
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

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