I am working on making a pivot table that shows Region 2's product 2 quarterly sales as a percentage of total sales. To accomplish this, I created a filter to find the sum of sales for these requirements. After that, I right click to change sum to show as a percent of the sum of sales column. However, once I did this, it gave me #NA. How would I fix this error? Thanks for the response.
Bookmarks