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

Hamza Jap-Tjong · 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

DRay · Answer

Hello Jack_Machesky . Did the response from HamzaJ provide you with a solution? If so, please hit the 'Accept as Solution' button so others with the same question can find the answer. If not, please let us know so we can continue to help. Thank you.