Hi All,
I need to create a summary table on product sales by countries and sort products by their sales in descending order. Products are in columns and regions are in rows. I also need to color top 2, 3-5 and 6-8 countries in each product. The below table is only a sample and i have much bigger table. From the below table, i am trying to get to sorting stage in which Product 3 should be the left most in the table and Product 7 has to be the last one.
Regarding coloring the cells in the Product 1 column, cells with 9 and 7 should be colored green because they are top 2 and 5 and 4 should be lighter green and the next 2 ranked ones should be more lighter green. I tried few ways to sort like sorting by other column etc but i am not able to solve it. Can any guide me on this ?
| Country | Product 1 | Product 2 | Product 3 | Product 4 | Product 5 | Product 6 | Product 7 | Product 8 |
| USA | 5 | 9 | 6 | 2 | 8 | | 8 | 3 |
| India | | 3 | 5 | 7 | | 2 | | |
| China | 3 | 5 | | | | 7 | | 4 |
| Japan | 7 | | 6 | 3 | 8 | | 8 | |
| Germany | | 3 | 5 | 5 | | | | |
| England | | 5 | | 6 | 4 | 6 | | 5 |
| France | 4 | | 2 | | | | | |
| Italy | | 1 | 5 | 9 | | | | 7 |
| Spain | 3 | 5 | | | | 7 | | |
| Australia | 9 | | 7 | 3 | 8 | | 3 | 8 |
| Total Sales | 31 | 31 | 36 | 35 | 28 | 22 | 19 | 27 |
Thanks
Srini
