Totals from outside of a pivot table

[Jack_Machesky]

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.

[HamzaJ · Accepted solution]

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

[DRay]

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.