3 Replies Latest reply on Nov 13, 2018 10:10 AM by Don Wise

What is the average profit ratio for all the products starting with C?

Hello experts

I am practicing Tableau and stuck at this question on Coffee Chain data set.

What is the average profit ratio for all the products starting with C?

options:  a) 30%

b) 25%

c) 33%

d) 20%

• 1. Re: What is the average profit ratio for all the products starting with C?

Hello Vani,

The calculation for Profit Ratio would be SUM([Profit])/SUM([Sales]) and formatted as Percentage.  A filter is applied using Products; I used Wildcard and set it to start with any Product starting with letter 'C'.

Then using Analysis drop down, provided a Grand Total and set it to Total as an Average.  33% would be the average of all Products starting with letter 'C'.  Hope that helps!  Thx, Don

2 of 2 people found this helpful
• 2. Re: What is the average profit ratio for all the products starting with C?

Thanks you so much Don for the detailed explanation.

• 3. Re: What is the average profit ratio for all the products starting with C?

Glad to have helped! Thx Don