This content has been marked as final. Show 2 replies
I have the following data:
In my straight table I have Customers going down the left and Products A, B, C will be across the top (I don't want to use a pivot table).
Is there an expression I can write that when I click on a SALESPERSON, the FIRST column will populate with the PRODUCT sold most by that sales person, then the next product, etc.
I will click John (Salesperson) and the straight table will show:
PRODUCT B PRODUCT A PRODUCT C
CLIENT ZZZ 500 400 300
I will click Jane (Salesperson) and the straight table will show:
PRODUCT C PRODUCT B PRODUCT A
CLIENT ZZZ 150 125 75
I would use a pivot table and sort by size, but I need to have multiple expressions. I need to have all of this data in 1 object since I will be exporting to the report function and will cycle through dozens of salespeople.
Thanks in advance for any help!