Getting the total from another Module

Atz1234

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.

AjayM

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!