Thank you Shiva! I think you calculated that 4.05 % is the revenue of all brands that have sales dollars <20 compared to the total sales revenue?
However, I would be interested in the percentage of brands that have sales dollars <20 compared to total number of brands.
Could you help me with that as well?
1 of 1 people found this helpful
Alexander Farr - Sorry, took me a while to get back to you. I think I was over thinking on this one. Here's what I did,
1) I created a dimension, that buckets Brands into 2 categories like so,
2) Then I create a another calc that does a DISTINCT COUNT of Brands.
3) I drop both these on view, and do a quick table calc of COUNTD(Brands) to show % of Total.
Is this what you're looking for?
Thank you very much, this is what I was looking for. Could you also upload the tpwb?