I want a way to calculate total item# by excluding duplicate returns that spanned over multiple months.
For example,
I have an Item # A001 which is a leather shoe which goes for a quality test but it fails in the month of June and comes back to the product floor, after making changes in the month of July it goes for a quality test and fails again. The process is repeated 3 times till it gets approved.
Similarly, Item# B001 is a sport shoe after 4 times going through quality it gets approved. So if we count for both the items it will be 7 times it got returned in the span of 6 months. Now here comes the tricky part, users like to see count as 2 times for those two items. In short, only the 1st return should be counted for each item.
Will the following expression work, Aggr(Count (Distinct Item Num) ,Return_mth) ?
