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

AnaplanXL Difficulties
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
Using Anaplan for Managing Custom Product Configurations (Example: Designer Dolls)
We’ve recently started using Anaplan to model and manage our supply chain and production planning for a niche ecommerce business that sells custom-designed dolls — each made-to-order with specific features, materials, and delivery lead times. A few interesting challenges we faced: SKU Explosion: Each doll can be customized…
Using time for something not time related - special characters :)$
We had a recent challenge with the need to "clean" invoice data descriptions from special characters. This was done previously in SQL with the a long convoluted formula "REPLACE(REPLACE(REPLACE('Ana&plan', '&', '') that would have to edited by a developer in case any new special characters came through. Using the replace…