SUM function based on User-specific filter

Ok, here's the situation:

- I have a transaction module

- The transactions are children of Cost Centers

- The transactions feed into a reporting module using a SUM function

- There are certain "special" cost centers that exist across different functions\parents in the Cost Center list

- I need to be able to give the users the option to: 1 - Only show the values for those "special" cost centers 2 - Show values excluding those "special" cost centers.

I thought I had this solved. I created a attribute that identified that "special" Cost Centers, a module to allow users to choose how to filter those "special" Cost Centers (filter and exclude) and incorporated those selections in the SUM formula. It worked great until I realized that the filter selection applied to ALL users. I need it to be user-specific.

Given my situation, is using a filter and incorporating that into a SUM formula that right path? I've considered an alternate hierarchy, but looks like a bunch of maintenance and tricky to maintain with the transaction detail and I think that would require separate dashboards. If the filter and SUM are correct, how do I do that? I have set up a user-specific filter, but I don't see how I can apply that filter to my SUM formula.

THANKS

Accepted answers

All comments

JaredDolich

@OSUBlakester I think you're really close to the solution already.

You can use the "current user filter" (see link) functionality. I think this is what you're looking for.

Let me know if you want an example. Would be happy to show you.

alexpavel

Indeed the solution is to use the "Users" list in your modules:

- add "Users" list a module with Cost Centers in order to define the "special" Cost centers

- add "Users" list to the module where the SUM is used and the filter is applied from the previous module

OSUBlakester

I was thinking that I needed to add the users to all of the other modules. Was hoping to avoid that. I can give that a try.

rob_marshall

@OSUBlakester

Blake!!!!!

What up? I think you have an example of this that I copied into your workspace, think User Filtering. The problem with using the Users list is it doesn't have a top level, and because it doesn't, you can't use the SUM function. To get around this, you will need a "fake" users list. I am out of town this week, but very happy to set up some time with you next week (Monday??) to review.

Rob

alexpavel

@OSUBlakester

A cell in a module can store only 1 value..and the cell is the result of the intersection of all the dimensions of the module.

Unfortunately, you cannot have different results of the same cell, varying by user.

So, every time when you want to have a different result that vary by a user you need to add to the module another dimension to differentiate the cells.

A way to solve this is by using the "Users" list.

The "Top" element of the users would create an intersection that is valid for ALL the users and would not answer the constraint to have a different result that varies by user.

ciao

Alex

andrewtye

Hey @rob_marshall
We're suffering the same problem albeit have got user filtering going on. How to get around having layers upon layers of calculation and model size is proving a head scratcher...

rob_marshall

@andrewtye

Please DM me so I can understand the "opportunity" a little better.

Rob

Quick Links

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
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.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385