I apologise if this is very vague however I don't really know where to start!
I'm trying to count/flag units that have been sold by any company and then returned to us and sold again by our company. As we don't record returned units to our company this has made the task much harder.
The aim is to show a percentage each month of returned units.
I really have no idea where to go with this but it is a very important piece of analysis.
Thanks tresesco any help will be greatly appreciated.
m.id_no (this is a unique number that is generated everytime the unit is sold)
these are the only fields that I think are relevant other fields we have are colour, price, type which I don't believe would help.
I was looking at using the unit.id as the dimension and the expression as match(unit.vendor, 'vendor1','vendorourcompany') but this would just show units that have been sold at some point by a vendor and our company which isn't what I am trying to achieve. Maybe doing something with match( but adding in if it has been sold by a vendor and then one month later sold by our company, this would then show the correct units.