I would like to create a column formula that provides a count of the number of distinct values in a column. I can use the Column viewer, Show summary function in JMP 15 but I want to have that value in a column for use in other calculations.
For example in the Big Class Table - N Items in column "Sex" should show 2 as 2 distinct values.