How to use SUM and LOOKUP dynamically
I have Order module(Region, Order)
Order(1,2...) comes from each Region. Order has Item and Amount.
I want to aggregate item-amount by dynamic Region like this table.
If Users chose the Europe, Item-Amount Table is aggregated by Europe.
I tried SUM and LOOKUP but I couldn't.
The point is I don't need Region List in Item-Amount table because it consumes memories.
And I don't want to use List Subset function because dynamic region setting has another dimension.
( I omitted the instructions to explain briefly)
Typical use case of SUM and SELECT or even SUM and LOOKUP. Since these compound functionalities need to be avoided due to Scalability and Performance issues I think Region dimension needs to be added in order for this to work.
Also, instead of giving the end user the flexibility to pick from pick lists, why don't use context selectors
Can you use the "dynamic selector" to create a dynamic filter on a saved view of the data table?0