user filtering to the top of a hierarchy

I am trying to do something that must be very simple but for the life of me i cannot work it out.
In this TEST MODULE i have a normal filter and i apply a logic to the sales volume stating if check? (the customer in the module = chosen customer) then sales volume else 0 and it works 100% as expected, removing the values and the total is as expected.

The second table is a user filter, same logic in line item, if check? (User Customer = customer) then Sales Volume else 0, and the filter on the UX is using current user, so hides the unwanted rows, so far so good.
BUT the Total shows the total for ALL customers. I need the total to ONLY show the filtered customer. How is this done?

thanks in advance

Accepted answers

kevin.stevenson

Do i just need to set the module as "Show ALL users : OFF"

All comments

Sai_Bharadwaj_Venati

Hi Kevin,

I believe your user filter is based on user dimension, if that's the case you have to have your Table 2 as well on User dimension

U can always filter based on user dimension but for showing proper data in sub totals you always require user dimension in module where you're filtering data or writing logic

kevin.stevenson

i have user dimension in my module 2 already

Sai_Bharadwaj_Venati

can you please share blue print of filter, output module?

kevin.stevenson

That's the data module and it uses the filter module SYS005.
The UX is then filtered on "User Filtered Volume" > 0 (current user, ALL periods)

kevin.stevenson

Do i just need to set the module as "Show ALL users : OFF"

Sai_Bharadwaj_Venati

Yes, that should solve the problem

Quick Links

Can you help?

Unanswered questions

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.…
Top-Down Allocations
Estimated Level of Effort:4-8 Hours of Model Building Level of Difficulty: Beginner Recommended Training: L2 Model Builder Training Persona: Casual Model Builder Potential ROI: Decreased planning time Increased accuracy of targets/spreads You Might Also Like: * Historical Snapshotting Top-Down Allocations Whether it's…
PowerPoint Add-in: Installation requires elevated privileges
This item has been identified as an outstanding known issue. A workaround is provided until the issue is officially fixed. Issue For versions 1.6, 1.7 and 1.8 of the PowerPoint Add-in elevated privileges are required to install the add-in through command line and for the "all users" option. Workaround * Installing through…