Companion Information

[tchooper7]

I have a sales table with product descriptikon, sales, gross profit et

How can I show that if a product using text filter includes 'lipitor' - I can see what other products were sold with this product ie could have been tissues -  each transaction is uniquely identified

[AlB]

Hi @tchooper7

Maybe you should try and explain in a bit more detail, including an example and the data model you have. I don't completely understand what you need and judging by the absence of answers so far, I am not the only one.

[tchooper7]

The below screen shot shows you what is returned when you ask the question what other products are sold with Lipitor (any strength) - does this assist 

[v-danhe-msft]

Hi @tchooper7,

Could you please offer a sample file and post your desired result if possible?

Regards,

Daniel He

[AlB]

@tchooper7

You might find this useful