cancel
Showing results for 
Search instead for 
Did you mean: 

Totals from outside of a pivot table

Jack_Machesky
9 - Travel Pro
9 - Travel Pro

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.

1 ACCEPTED SOLUTION

HamzaJ
12 - Data Integration
12 - Data Integration

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

View solution in original post

2 REPLIES 2

HamzaJ
12 - Data Integration
12 - Data Integration

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
Community Team Member
Community Team Member

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.

David Raynor (DRay)