Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

View showing lowest price per category/sub-category

Solved
Jump to Solution
1209 2
cancel
Showing results for 
Search instead for 
Did you mean: 
100grammes
4 - Data Explorer
4 - Data Explorer

Hi,

I need to supply to my team of buyers the "best deal" for any given category and sub-category of products in our database. At first, it was easy to group by category / sub-category into a view sorted by price ASC. But over time, the database grew big and we now have 7000+ products splitted into 25 categories and 50 sub-categories ...that makes it long and tedious to scroll through this view to locate manually the cheapest product for each category/sub-category combo (about 150 unique combinations in total).

My question: is there a way to get a view that'd output the best product per category / sub-category combo in a flat table format. In other words, this view would contain ONLY the 150 best deals.

Many thanks!

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

Have you looked into back-and-forth rollup fields? A rollup field that shows the lowest price. Then another rollup that brings that lowest price to the item. Then a formula field that checks if the item is the lowest price. Finally, another conditional rollup of the name of the item with the lowest price.

See Solution in Thread

2 Replies 2
kuovonne
18 - Pluto
18 - Pluto

Have you looked into back-and-forth rollup fields? A rollup field that shows the lowest price. Then another rollup that brings that lowest price to the item. Then a formula field that checks if the item is the lowest price. Finally, another conditional rollup of the name of the item with the lowest price.

100grammes
4 - Data Explorer
4 - Data Explorer

It works!