2 of 2 people found this helpful
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
Thanks you so much Don for the detailed explanation.
Glad to have helped! Thx Don