gilquenanoviii
New Member
- Joined
- May 18, 2022
- Messages
- 26
- Office Version
- 2021
- Platform
- Windows
Good day everyone,
hoping you can help me if there is formula that I can use to autofill up this top 5 best seller by quantity and by value report that I have using the pivot table given.
In Pivot table - Subdepartment, there are different classes like (Bags & backpacks / Arts & crafts / Notebooks & Pads)
and I wanted to know if there is anyway that I could get the top 5 best sellers by Sales and Quantity sold automatically with the use of a certain formula.
I need to get the SKU - TITLE - and Sum of Sales arrranged from Largest to Smallest.
Thank you in advance for help and support.
hoping you can help me if there is formula that I can use to autofill up this top 5 best seller by quantity and by value report that I have using the pivot table given.
In Pivot table - Subdepartment, there are different classes like (Bags & backpacks / Arts & crafts / Notebooks & Pads)
and I wanted to know if there is anyway that I could get the top 5 best sellers by Sales and Quantity sold automatically with the use of a certain formula.
I need to get the SKU - TITLE - and Sum of Sales arrranged from Largest to Smallest.
Thank you in advance for help and support.