I have a the sample data pasted below.
n/a values. Basically as the Group changes we have to see if in previous products the values which already appeared should not be counted.
This calculation can be performed with some tricks and trips in small sample data but for the cases where our record uniqueness is displayed using 22-23 fields, I don't think its possible to do this in tableau.
There are two ways to handle this scenario through Table Calculation and Pivoting but with this kind of dataset it @gets way complex when deriving the granularity of the record. Please suggest with your experience on this.