medium10 pts · first answer countsexcelpivot-tables

Share of sales in a pivot table

Your pivot table shows sales by region. A manager wants each region as a share of total sales. What is the cleanest way?

A.Copy the pivot to a new sheet and divide each cell by handB.Add a calculated field that divides Sales by 100C.Set the value field's Show Values As option to % of Grand TotalD.Sort the regions so the biggest is first

Discussion 0

Join free to post in the discussion.

Share of sales in a pivot table

Discussion 0

Related questions