Showing a static measure in a table with an unlinked dimension

[Hope_AA]

Hi,

I have a table with number of tests per month per department and I have another table (not linked to the first) with financial account numbers. I need to show the sum of tests per date on each account number and need that to still respond to filters on  department or month.

This is an example of what I have:

and this is how I want it to show in the other table:

noting that there are many variations of months & departments.

how can I achieve that?

appreciating all the help;

[Or]

Perhaps Sum({< Account_Number = >} Tests) would help here? I'm not entirely sure if that's what you're trying to do or not.

[Hope_AA]

This is what I want but I tried with that set analysis but it's not working. I also tried sum(Total Tests) but it's duplicating the total in each month as well as in Total tests.

[Or]

In the suggested formula Account_Number would need to be replaced with the appropriate dimension name, of course. You could also try Sum(Total <Month> Tests), perhaps.

[Hope_AA · Accepted solution]

Thanks for your help. I had to make some joins before using that set analysis.