So you can insert a new column in the source data and calculate the profit margin in it. Go back to the original data set and add this new data point.Now, what if you also want to know what was the profit margin of these retailers (where the profit margin is ‘Profit’ divided by ‘Sales’).
The above Pivot Table summarizes the sales and profit values for the retailers. Suppose you have a dataset of retailers and you create a Pivot Table as shown below: Let’s start with a basic example of a Pivot Table.
