Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how to retrieve top 5 products from each sub-category wise as well as each category wise
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.
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.
Hi Tanish,
Thank you
Hi @Rajitha1 ,
If solution is right, please mark it as Solved. It would be helpful for others to refer.