Totals from outside of a pivot table

Question

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

HamzaJ · Accepted Answer

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: https://docs.sisense.com/main/SisenseLinux/dashboard-functions-reference.htm?tocpath=Dashboards%7CFormulas%20and%20Functions%7C_____12