Summary in UX Page

Hi everyone,

I have a module which is dimensioned by 'L3' List. It hold amount data. I want to filter l3 list by Region. So, I have added a region filter and published as a 2nd grid in the same Page. But, in the Summary for the 2nd grid, is there any chance that I will get only sum of the list items that are filtered out.

For example:

For list item '2' in the second grid, can I get 545 , instead of 547(which we are getting by summing up all list items under '2') . Is there any such way?.

Thanks.

Accepted answers

TristanS

You will have to create a new line item in the module that is referenced in grid 2. For example, call it "amount x". The formula will then be

if filter.region = grid2.region then amount else 0

Hide the original line item amount and display Amount X in grid 2 UX

All comments

TristanS

You will have to create a new line item in the module that is referenced in grid 2. For example, call it "amount x". The formula will then be

if filter.region = grid2.region then amount else 0

Hide the original line item amount and display Amount X in grid 2 UX

Quick Links

Can you help?

Unanswered questions

Level 3 - DAT02 PY Revenue to CY
Hello all experienced MB's Created a Module to Pull PY revenue to CY, Module has dimensions A2 Account>Product# and G2 Country. Whatever country I select the value shown is for ALL regions This is something to do with aggregations, but I'm struggling to figure out which is correct, surely SUM is incorrect. Any suggestions?…
Selection of multiple option from list on UX pages
Hello Anaplaner, Please find the attached Excel sheet along with the use case description below. We have a use case where the end user requires a selection option on the UX page from a list (Product & Company). As you may be aware, there is currently no option available on the UX page to select multiple list members from a…
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…