Getting the total from another Module
Hi everyone i have a module [Employee Details] where i can filter the team center. for the below sample, i chose the Financial System which has 2 employees. whenever i choose Team Center, the amount will be selected in [Sum Selected] column. in my Testing 1 module, the only Total would reflect must be Financial System. but unfortunately, all total displayed in the record.
Answers
-
Hi @ArthurAng ,
I believe when you said selecting 'Financial systems and Administration', you are selecting from the page selector. Since all other items are technically avaialble in the list, the 'SUM SELECTED' column would return values for respective items. Hence your testing1 module would return values for all items.
Instead, separate the team selection into a different lineitem which is either by user dimension or no dimensions. And then modify your 'filter result' formula to be based on this new selection lineitem. This will help to get desired outcome in your testing module.
Below solution (consider regions instead of your teams). Note that whenever 'select region' selection is changed, you will need to refresh the UX page. Instead you can dimension the selection by users list, and all the downstream calculations as well by the users list, to avoid refreshing of page.
Cheers!1 -
I find issue with Filter Result lineitem. Can you check if you change the item of context selector in Employee Details module then Is it checked for other Team center as well?
Regards,
0 -
Well, you can create similar lineitem in employee details module as well, but without any dimension. Basically, the selection should be independent. Instead, if you use the page selector, it simply means to calculate result for every item in the list, but show only for whatever is selected in the page selector. This won't help with your summary calculation.
Check below the difference. 'Filter result (context)' and Sum Selected (Context) are what I believe you initially had:
Cheers!
1
