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 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?.