Dear All
I have created a PivotTable to summarise profit margin from sales to various customers. Now, I want to calculate the profit margin % earned but the PivotTable does not allow me to create a Calculated Field "Profit/Sales".
What can I do?
PivotTable to calculate profit %.png
Thank you!
Joseph
In the attached copy of the file a measure has been added to the Table 1 in the Active tab of the Field List.
The measure name is Profit % and the formula is: =SUM(Table1[Profit])/SUM(Table1[Sales])
The measure is then dragged into the Values area of the Field List and percentage formatting (0 decimal places) is applied.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Perfect! Thank you JeteMc! Here is a Rep for you.
You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.
Oh ya, thank you also for showing the steps to set up the measure. You have a blessed weekend!
Last edited by josephteh; 10-30-2020 at 10:11 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks