Identify top 80% revenue with multiple criteria

Hi BK_Bangkok 

I guess this should be possible with a pivot table:

Put the category and SKU's in the rows range (I just use a simplified example)

Put the revenue in the values range

Put the revenue a second time in the values range.

Sort the SKU field descending by revenue:

Then put a values filter on SKU:

Change the value field settings on the second revenue field:

Chose "Rank Smallest to Largest" based on SKU field:

Then, your pivot table just shows the top 80% and you see also the rank (in revenue2). As the table is already sorted by revenue, the rank is not really necessary, but it helps if you change the sorting.