Sum of Unique Count of 1 value in 1 Column based on condition on 2nd Column
Here is a simplified data set with only 3 columns and 7 rows (column names are made up but share the same nature):
Population Density is static within its corresponding Group, Location(s) is the one having variable values even within each Group.
What I'm trying to do is to count the number of unique Group where Population Density = High and sum that up. So in the above data set, the result should be 2 (Group A & Group B).
Is that doable in Spotfire using Insert Calculated Column? if not, what will be the workaround? My Spotfire level is only at Intermediate level since I self-learn a lot from playing around with it.