Chandrashekar.A
New Member
Is there any way to get unique records in pivot table rather than adding a new column and use below mentioned formula to get unique a value in pivot table..
=1/Countif("$A$1:$A$10,A1)
=1/Countif("$A$1:$A$10,A1)