Filtering on user - Data is incorrect
I have a module with list of employees who belongs to different countries .I have created a user filter on country selection . Now when user selects a country ,the list of employees shows the relevant employees.
But problem is total ,say total salary is not as per selected country ,it will be of all employees from different countries. Is there any way to show total also based on user selected item .
Note: - Cant use users as dimensions of module because of size issues .