This content has been marked as final.
Show 3 replies

1. Re: Sum distinct values within two categories
Chris McClellan Sep 4, 2017 5:43 PM (in response to Daniel Corcoran)2 of 3 people found this helpfulI'm assuming all the population figures for the LGA in that year will be the same, so I used a MIN() rather than a SUM()

2. Re: Sum distinct values within two categories
Daniel Corcoran Sep 4, 2017 8:54 PM (in response to Chris McClellan)1 of 1 people found this helpfulThanks Chris,
This calculated doesn't work when put back into the original table, I want something that shows the sums while ignoring the filters of the table. I suspect it will be a two step lod expression, still not sure how to solve it.

3. Re: Sum distinct values within two categories
Daniel Corcoran Sep 4, 2017 8:56 PM (in response to Daniel Corcoran)1 of 1 people found this helpfulJust solved the problem by nesting two fixed expressions, thanks for pointing me in the right direction.