calculated field in tableau with categories

Question

I have a dimension with 3 categories and a measure of total sales count I want the ratio between one item of the category and the total

for example - I have a measure of fruit (Apple, Orange, Strawberry) I want the ratio of apple sales divided by total sales

Having trouble with the syntax

sum(([sales(fruit)='Apple']))/sum([sales])

 

Answer 1

• You can use a conditional aggregation to do that. Basically, you just embed an if statement inside of the aggregate function like so:

SUM(IF [fruit] = 'Apple' THEN [sales] END) / SUM([sales])

• The numerator SUM ignores all non-Apples, while the denominator includes all fruits.