Help

Re: View showing lowest price per category/sub-category

Solved
Jump to Solution
633 0
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!