Calculate number of distinct items removed from list and what items they are

[Jameswhittle91]

Hi, I'd like to calculate the number of items that remove from a list each week. essentially each shopping list has been appended into one master table. I'd like to find the number of items that are no longer on the list (I have a shopping list number column) and what these items were. How would i go about achieving this?

Many thanks in advance for any help

[mbamber]

You can create a list of values for the current week and the same list for the previous one. And then INTERSECT will help you.

[mlsx4]

Hi @Jameswhittle91 

Can you provide an example with some "dummy" data and your expected output? At least, how is your data structured. If you cannot do it, please check this video: https://www.youtube.com/watch?v=u2ImJFc1B7c

The same logic that applies for lost customers will apply for your data