I'm not certain I understand the question - are you just counting the number of distinct brand and dividing by the total brands?
that would return
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
No, in essence I need to calculate an average of an average. In my example it would be (43.75+34.38+21.88)/3 = 33.33%; it is just a coincidence that your total matches what I'm looking for!
Does that make sense?