Gain and Loss

I like to show how many pieces of any product has been sold by all those who bought a certain product in a certain year but not the following year.

Let’s look at an example:

Using my filter in the dashboard I could chose Year = 2015 and Product = A. Then I like to show/measure how many pieces of any product has been sold BUT ONLY for Ids who bought Product A in 2014 AND NOT in 2015.

Looking into data I can see that ID 1 bought Product A in 2014 but not in 2015 (product C and B should appear then appear in my bar chart).

ID 2 has bought Product in 2014 and 2015 as well and thereby shouldn’t appear.

ID 3 bought Product A in 2014 but not in 2015 (product C should appear then appear in my bar chart).