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