Results 1 to 6 of 6
  1. #1
    2 Star Lounger
    Join Date
    Jul 2006
    Location
    Bangalore, India
    Posts
    180
    Thanks
    1
    Thanked 0 Times in 0 Posts

    % of Row in Pivot (Excel 2003)

    Hi Excel Experts,

    Excel Sheet with Dept Col A, Gender Col B and Level Col C

    I have created a pivot deptwise, with header Level and distribution of gender levelwise. I have used % of row option, and give me a break-up across grade to 100%

    Is there a option of way to get the % break-up of gender under each Level dept wise.. i.e. 100% split of Group 3 level.

    Attached is the excel sheet with the pivot. and the i have highlighted the desired result.

    Looking forward to a simple but great solution.

    Regards
    Baiju

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: % of Row in Pivot (Excel 2003)

    As far as I know, Excel doesn't offer this option in pivot tables, so I think you'll have to create your own formulas. If I'm wrong, no doubt someone will correct me.

    BTW, was the reply to <post:=659,201>post 659,201</post:> helpful?

  3. #3
    2 Star Lounger
    Join Date
    Jul 2006
    Location
    Bangalore, India
    Posts
    180
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: % of Row in Pivot (Excel 2003)

    Hi Hans,

    What would be the formula or logic i should use to get the desired result?

    Apologies for not reponding to your macros on post 659,201 did help me thanks was able to organise a totally disorganised database. got held up with something urgent and could not reply

    Regards
    Baiju

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: % of Row in Pivot (Excel 2003)

    I have attached a very crude example.

  5. #5
    2 Star Lounger
    Join Date
    Jul 2006
    Location
    Bangalore, India
    Posts
    180
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: % of Row in Pivot (Excel 2003)

    Hi Hans,

    Thanks for curde example, will really help me a lot till such time someone else comes with a greater solution ;-)

    Regards
    Baiju

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

    Re: % of Row in Pivot (Excel 2003)

    You are (unsurprisingly) not wrong! <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    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
  •