Rank top 3 Products with highest satisfaction rating

Hi,

1. So, how to obtain the top 3 products with highest satisfaction rate? Is there a way to do it using pivot table (preferably with slicers) in an automated fashion?
2. What would be the best way to sort it out the top 3 products without using filters? Besides the ‘affected product’ column, there’s another column with ‘0’ for dissatisfied rating and ‘1’ for satisfied rating. Which I tend to use as way to calculate the satisfaction % (positive surveys ÷ total surveys).

I need some help with a spreadsheet that I cannot change the source data (raw data), which is extracted from a report.

Basically, I need to identify the products with highest satisfaction rating among a plethora of products, in a single column with data that goes from smartphones, tablets, computers, smart keyboards, all the way to cloud services and accounts.

I was thinking of SUMPRODUCT to conditional ranking (couldn’t do it), or categorize the products and make a graph out of it, but I’m really lost on this one.

I really need some help here ):

Thank your for the insights, I wasn’t aware of this and the rules makes sense. Ill be vigilant from now on and since there’s two post, I’ll make sure that the users whom dedicate their time to reply and help me in this journey to solve this issue, will receive the proper salute

Lets see if it is what you want.

Originally Posted by DJunqueira

Lets see if it is what you want.

Thanks for the answer, it’s almost that. The issue is that the rank (or list) can’t have things that are not hardware products.