Count of the row

Giganews Newsgroups
Subject: Count of the row
Posted by:  navin (navin.naraya…
Date: 3 Jan 2007


i have this sheet which contains user information. User name in the
sheets are repeated. I have used pivot tables to display this data.
However, I also want a column which shows the total number of users.
Currently, when I select "Count of user name" in the pivot, it counts
all the existing user names but i want it to display only distinct user
name (i.e), it should not count the repeated the username.

Please help.