1 Reply Latest reply: Oct 15, 2013 2:16 AM by David Norton RSS

    Profiling - Distinct Field Values (per field)

    David Norton

      Hi Everyone,


      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.


      Any ideas?