1 Reply Latest reply: Feb 14, 2014 7:04 AM by Manish Kachhia RSS

    How to count the non unique values  per field in a pivot table?

      Hi, How do I count the non-unique values per field in a pivot table?

       

      sample output:

       

                                                   Field1          Field2      ....

      Number of duplicates          5               20

      % to total                              1%          50%

       

       

      Thanks a bunch in advance. Cheers!