Rank country for sales of technology products

Question

How to rank products for technology category by sales per quantity ? I'm using global superstore data set.

Answer 1

Hi Kartik,

Follow the below steps:

1. Add the category in the filter and select technology.

2. Now select Sales and Product-id/name in the sheet.

3. Right click on the sales field and go to Add Quick Calculation and select Rank.

4. Add sales again on the sheet to show rank-wise sales for each product from the technology category.

Hope it helps you.