@tragicwhale It can be done in the UI by grouping the results by Item, and then using a formula for each column you want, something like

DECODE({privelevel}, 'Price Level 1', {price}, 0)

and summary type maximum. (Those are probably not the real field names..) Let me know if you need me to elaborate.

hey michoel, this definitely intrigued me, I'd love if you could elaborate

Sure, just popping into a quick meeting and then I'll give more details

please, take your time, you are helping me out👍

Here's a screenshot

hey michoel, did you attach a screenshot?