Suppose in "Big Class" I'd like a formula that counts the number of unique names of people at or less than the height of the person in the current row. How can I do that?
I have this:
thisHeight = :height;
Col N Unique( :name, :height <= thisHeight );
I realize the second parameter is the grouping parameter, and it's more intuitive to try to constrain what gets passed into the first parameter, but I haven't had any luck with anything I've tried to this point.