3 Replies Latest reply on Aug 3, 2018 5:04 PM by Ken Flerlage

    Showing Top Items that a Customer *Doesn't* Sell (or vv)

    Steve Riffe



      I've had a good search for this and come up short.


      Attached is a simple workbook which has a dashboard showing the Top 3 Items and the Top 3 Customers for a particular company. The way the actions are set up, if a user clicks on a Top Item, they see the Top Customers that bought it. Likewise, if you click on a Top Customer, you can see which of the Top Items they've purchased.


      However, I'd really like the inverse of this: showing the Top Items that a customer *isn't* purchasing (and vice versa, a list of Top Customers that aren't purchasing a Top Item).


      Does anyone know a simple way of doing this? The data source is MS SQL.


      Many thanks in advance!