Solved
Totals from outside of a pivot table
I was wondering if it is possible to add a value column to a pivot table that calculates a percentage of sales from a total number that is outside of the table itself. In the table, I have total sales values for customers with names that start with a certain letter. I achieved this by modifying the customer name column to only include those customers with the specific letter starting their name, but I would like to take this totaled column and divide it by all customers available, not just those shown in the table.
Hey Jack,
I think you are looking for the ALL-function. With this function your calculation can bypass filters and thus calculate a total that goes beyond the customers you have selected:
