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

[#1]

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!

[MK_QSL]

Please check enclosed file..