topic Re: Showing a static measure in a table with an unlinked dimension in App Development

Showing a static measure in a table with an unlinked dimension

Hope_AA — Mon, 22 Nov 2021 17:06:49 GMT

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;

Re: Showing a static measure in a table with an unlinked dimension

Or — Mon, 22 Nov 2021 17:57:42 GMT

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

Re: Showing a static measure in a table with an unlinked dimension

Hope_AA — Mon, 22 Nov 2021 18:04:22 GMT

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.

Re: Showing a static measure in a table with an unlinked dimension

Or — Mon, 22 Nov 2021 18:09:37 GMT

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.

Re: Showing a static measure in a table with an unlinked dimension

Hope_AA — Mon, 06 Dec 2021 19:34:28 GMT

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