Summary in UX Page

Saisri8568
Saisri8568
in Modeling

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:

Saisri8568_0-1659448690313.png

 

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.

 

 

Tagged:

Best Answer

  • TristanS
    TristanS
    Answer ✓

    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

Categories