Hi everyone, I am trying to create a table that first rank the brands (top 5) by sales volume, grouped by product category. Then, for each of the top 5 brands, find the week on week sales performance.
Product Cat. | Brand Rank | Brand | Sales | Sales LW | Delta |
|---|
| X | 1 | ABC | $1200 | $1000 | 20% |
| 2 | DEF | $500 | $1000 | -50% |
| 3 | FG | $100 | 0 | 100% |
| 4 | HH | $50 | $25 | 200% |
| 5 | IJ | $10 | $10 | 0% |
| Y | 1 | AA | $500 | $100 | 500% |
| 2 | BB | $300 | $600 | -50% |
| 3 | CC | $200 | $100 | 100% |
| 4 | DD | $150 | $1000 | -85% |
| 5 | EE | $100 | $200 | -50% |
| Z | 1 | | | | |
| 2 | | | | |
Any possible solution is welcomed. Thanks in advance.
Cheers,
Eng Xiong
