coolguyvarun01
New Member
- Joined
- Jan 5, 2015
- Messages
- 27
- Office Version
- 2019
- Platform
- Windows
Hi Experts,
Need your help in this. My boss wants me to create values for a group of materials bifurcated on basis of pack x Channel, now the values for a pack/channel combination should sum up to 100.
<tbody>
</tbody>
Need your help in this. My boss wants me to create values for a group of materials bifurcated on basis of pack x Channel, now the values for a pack/channel combination should sum up to 100.
Unit | Brand | Channel | Pack | Value% |
EAST | Product 1 | Insti | Medium | |
EAST | Product 1 | Insti | Small | |
EAST | Product 1 | Railways | Medium | |
EAST | Product 1 | Railways | Small | |
EAST | Product 1 | SAMT | Medium | |
EAST | Product 1 | WS | Medium | |
EAST | Product 1 | WS | Small | |
EAST | Product 1 | TT Retail | Medium | |
EAST | Product 1 | TT Retail | Small | |
EAST | Product 1 | Spoke | Medium | |
EAST | Product 1 | Spoke | Small | |
EAST | Product 1 | SAMT | Small | |
WEST | Product 2 | Insti | Medium | |
WEST | Product 2 | Insti | Small | |
WEST | Product 2 | Railways | Medium | |
WEST | Product 2 | Railways | Small | |
WEST | Product 2 | WS | Medium | |
WEST | Product 2 | WS | Small | |
WEST | Product 2 | TT Retail | Medium | |
WEST | Product 2 | TT Retail | Small | |
WEST | Product 2 | Spoke | Medium | |
WEST | Product 2 | Spoke | Small | |
WEST | Product 2 | SAMT | Medium | |
WEST | Product 2 | SAMT | Small | |
NORTH | Product 3 | Insti | Medium | |
NORTH | Product 3 | Insti | Large | |
NORTH | Product 3 | Spoke | Extra Large | |
NORTH | Product 3 | TT Retail | Medium | |
NORTH | Product 3 | TT Retail | Large | |
NORTH | Product 3 | TT Retail | Small | |
NORTH | Product 3 | TT Retail | Extra Large | |
NORTH | Product 3 | WS | Medium | |
NORTH | Product 3 | WS | Large | |
NORTH | Product 3 | WS | Small | |
NORTH | Product 3 | WS | Extra Large | |
NORTH | Product 3 | Spoke | Medium | |
NORTH | Product 3 | Spoke | Large | |
NORTH | Product 3 | Spoke | Small | |
NORTH | Product 3 | SAMT | Large | |
NORTH | Product 3 | SAMT | Small | |
NORTH | Product 3 | SAMT | Extra Large | |
NORTH | Product 3 | Railways | Extra Large | |
NORTH | Product 3 | SAMT | Medium | |
NORTH | Product 3 | Railways | Medium | |
NORTH | Product 3 | Railways | Large | |
NORTH | Product 3 | Railways | Small | |
NORTH | Product 3 | Insti | Small | |
NORTH | Product 3 | Insti | Extra Large | |
SOUTH | Product 4 | Spoke | Large | |
SOUTH | Product 4 | Spoke | Medium | |
SOUTH | Product 4 | Spoke | Small | |
SOUTH | Product 4 | Spoke | Extra Large | |
SOUTH | Product 4 | TT Retail | Large | |
SOUTH | Product 4 | TT Retail | Medium | |
SOUTH | Product 4 | TT Retail | Small | |
SOUTH | Product 4 | TT Retail | Extra Large | |
SOUTH | Product 4 | SAMT | Medium | |
SOUTH | Product 4 | SAMT | Small | |
SOUTH | Product 4 | SAMT | Extra Large | |
SOUTH | Product 4 | Railways | Extra Large | |
SOUTH | Product 4 | SAMT | Large | |
SOUTH | Product 4 | Railways | Large | |
SOUTH | Product 4 | Railways | Medium | |
SOUTH | Product 4 | Railways | Small | |
SOUTH | Product 4 | Insti | Medium | |
SOUTH | Product 4 | Insti | Small | |
SOUTH | Product 4 | Insti | Extra Large | |
SOUTH | Product 4 | WS | Extra Large | |
SOUTH | Product 4 | Insti | Large | |
SOUTH | Product 4 | WS | Large | |
SOUTH | Product 4 | WS | Medium | |
SOUTH | Product 4 | WS | Small |
<tbody>
</tbody>
Last edited: