Filtering on user - Data is incorrect

Hi ,

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 .

Thanks

Accepted answers

All comments

KirillKuznetsov

I would suggest to have nested hierechy with Country-Employee linkings. This way you will get a subtotal per each country.
Or you can create a separate line item dimentioned by users to calculate total per selected country (using SUM for example).

Misbah

@shadmani

Create another module dimensioned by country and use SUM function. Then create a Filter line which has to be dimensioned by Users as well as Countries.

Hypothetically if there are 250 countries and 1000 Users in your model, we are talking about 2 -3 MB of additional space consumption. Unless and Until you have 100,000 users in your model you are not going to consume space in GBs.

Hope that helps

Misbah

shadmani

@KirillKuznetsov

Thanks for the workaround . I am going with second approach .

Looks like there is no direct solution . Need to split data employee level and other summary level .

shadmani

@Misbah Thanks for your reply .

Got your point . Yes we are following the same approach but client preference was to see everything in 1 view instead of toggling between 2-3 views .

ChrisAHeathcote

@shadmani

To ensure that the totals calculate as per the user selection you need to add the users list as a dimension and calculate the output based on the selection for each user.

Your are effectively creating a separate view for each user based on the mapping in the filter module.

ChrisAHeathcote

@shadmani

The most effective and efficient solution is to create a parallel hierarchy where country is the parent of each employee.

You will need to create a duplicate employee list and map the data from where it is currently calculated into this new list. Therefore, add a property to the new employee list which maps it back to the mast employee list.

Add the new dimension to a module and use LOOKUP to map the data from the calculation module into the new hierarchy.

Now you can publish this to a dashboard and use hierarchy filters to allow the user to select a country from the page selector. Or use the the existing filter set up but filter the new employee list rather than the original.

Create an action which updates the new list and add this to the process which is used to create the master list. Also, tie in the deletion from this list when an employee is removed from the master list.

Quick Links

Can you help?

Unanswered questions

import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…