Creating a formula field and using it as a measure
In your dataset, you can use this definition to create a formula field that shows profit percentage:
% Profit Formula = {estgrossprofit}/{amount}
The formula field column gives a percentage value for each entry. For example, the % Profit (formula) column shows a value for each of the three entries for Sales Order 100537: 18%, 100%, and 100%.
If you use this formula field as a measure in a pivot table, the returned value is 72.67%, which is not entirely accurate.
(18% + 100% + 100%) / 3 = 72.67%
