Hi, I just wanted to analyse the data in excel using Pivot table. Data is quite huge. But I just need few columns details and duplicated to be removed and I got the distinct counts of specific columns.. But when I click that counts, I couldn't see the distinct details of that selected column alone. Getting overall details with duplicates. Is there any option or way to get that resolved? It would be really helpful if there is any way to get that done easily... Thank you..