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

    How to display percentage of filtered value over unfiltered value

    I appreciate your time on replying, Narayan and Prasad, maybe I didn't interpret my need clearly. Actually the old post was the very first one I searched on google, but it's different than my case. I'm not looking for the % over unfiltered "total", but over the unfiltered number in this exact...
  2. W

    How to display percentage of filtered value over unfiltered value

    Hi Prasad, thanks for your post but this isn't what I want. Take the cell of Age = 21 and Height = 5'7", the population is 77 and Male is 54, I want to display the percentage of 54/77 = 70%, not the percentage of row or column or total. Any idea how to config the fields? Thanks.
  3. W

    How to display percentage of filtered value over unfiltered value

    Greetings, I've been struggling with this for a long time and I believe someone here can answer this: My pivot table is as this: Height/Age 20 21 22 5'7" 45 77 98 5'8" 53 109 124 5'9" 68 117 155 When I enable a filter of "Gender = Male" the numbers are...
Back
Top