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 sale...
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:
