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

Top Rank (50% of Row Total)

hardeep.kanwar

New Member
Hi!!!

I have data Zone, Outlet, and Sales and I Create Pivot Table from this Data


I need those Top Outlet who have Contribute 50% of the Total Sales against Each Zone.


For example, if Zone A has 10 Outlet and their Total is 127, what I need to highlight or who have achieved 50% from the total Sales

In below Example Result is A,B & H

Zone

Outlet

Sales

Delhi

A

20


B

30


C

5


D

4


E

2


F

1


G

0


H

28


I

19


J

18

Delhi Total


127
 
@hardeep.kanwar

Use below instructions to highlight top 50% items.
  1. Right click on any value in pivot and sort Largest to Smallest
  2. Go to Conditional formatting > Top / Bottom Rules > Top 10%
  3. Change the rule to 50% and click ok
  4. You will see a tiny formatting options icon next to the selected cell. Click on it and apply the formatting rule to All cells showing "Sum of Secondary" values for "Name of outlet"
  5. Done
 
Back
Top