Is there a good way, when profiling a new data set, to show the distinct values per field?
I've got the following working in a straight table (with dimensions $Table and $Field), when any single field is selected:
=Num(Count(Distinct [$(=$Field)]), '#,##0')
...but ONLY when a single field is selected. If 2+ fields are selected, the straight table is blank. It would be immensely helpful to see the distinct values in each field.