How to search for a value but do not filter the data for the filtered value?

We have created some cool pivot tables which have a customer and user level performance data in it. When the dashboard user searches for a specific user from a customer, because of the calculations we used percentoftotal as a calculation by customer name, at any given search the % of total output is becoming 100% because the users within the customer are getting filtered to only one row and that row is getting 100% value.

Is there a way through which we can search and look for a record but not certainly filtering for that record?

Have you looked into adding PRE_FILTER to the calculation?

1 Like

Hi @Ganapathi_Kakkirala
Level aware calculations will be useful here. More specifically in the denominator of your percent of total calculation, you can calculate that at a level excluding the user field. The post below should be helpful.