AnsweredAssumed Answered

How to filter data with (not)exists?

Question asked by raym on Jul 17, 2018
Latest reply on Jul 18, 2018 by breuber

Hi all,

 

I'm trying to select customers that buy a certain product (sql equivalent of exists). And I want to display their total sales, not just those of that product. Similarly I want to search for customers that don't buy a certain product and display their sales.

How'd you best achieve that in a dataview or for the whole screen?

 

BR, Ray

Outcomes