Top Rank (50% of Row Total)

[hardeep.kanwar]

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

 

[NARAYANK991]

Hi ,

Can you upload your workbook with the data and the pivot table in it ?

Narayan

 

[hardeep.kanwar]

File Attached

 

[NARAYANK991]

Hi ,

The uploaded file has neither the raw data nor the pivot table. Please upload the desired file.

Narayan

 

[hardeep.kanwar]

updated with raw data

 

[r2c2]

@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