5 Replies Latest reply on Oct 20, 2018 10:07 PM by ShivaRam Chennapragada

# Percentage brands under 20 dollars

Hello everybody,

I have a dataset on sales and want to sort this by brands. Additionally, I would be interested to find out the percentage of brands with sales <20 dollars / total number of brands. I have tried several formulas for calculated fields but they did not work.

I would really appreciate your help.

Thank you!

• ###### 1. Re: Percentage brands under 20 dollars

See if this helps,

Best,

Shiva.

• ###### 2. Re: Percentage brands under 20 dollars

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?

Thank you!

• ###### 3. Re: Percentage brands under 20 dollars

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?

Best,

Shiva.

1 of 1 people found this helpful
• ###### 4. Re: Percentage brands under 20 dollars

Thank you very much, this is what I was looking for. Could you also upload the tpwb?

Thank you!

• ###### 5. Re: Percentage brands under 20 dollars

Sorry, here you go.

1 of 1 people found this helpful