#Brand# | Nike | Lining | Adidas | ...... | |||
Sales | Ratio | Sales | Ratio | Sales | Ratio | ...... | |
May | 130,000 | 100 | 56,000 | 43 | 110,000 | 85 | ...... |
June | 120,000 | 100 | 44,000 | 37 | 99,000 | 83 | ...... |
#month# | ... | ... | ... | ... | ... | ... | |
=100*(Lining sales/Nike sales) | |||||||
=100*(Adi sales/Nike sales) | |||||||