How to retrieve top 5 products from each sub-category in each category

[Rajitha1]

how to retrieve top 5 products from each sub-category wise as well as each category wise

[Tanish · Accepted solution]

Hi @Rajitha1 ,

Let me tell you the simplest way.

1. Create a Pivot Table 

2. Add your fields - Category , Sub-Category , Product , Sales

3. Under Product tab set limitation as 5 or you can make it dynamic as well through Variable input.

Attaching the screenshot as well for your reference.

Hope this will help.

[Rajitha1]

Hi Tanish,

Thank you

[Tanish]

Hi @Rajitha1 , 

If solution is right, please mark it as Solved. It would be helpful for others to refer.