I got 7300 entries, while I have excel displaying only 2400. Also, everytime create pivot for the same data, the count keeps changing i.e. 2439, 2500..
Kindly Advise
Also, the same colum while droped into value, displays a count of 7300
I got 7300 entries, while I have excel displaying only 2400. Also, everytime create pivot for the same data, the count keeps changing i.e. 2439, 2500..
Kindly Advise
Also, the same colum while droped into value, displays a count of 7300
Please attach a sample of your workbook so we can use your own data to work on possible solutions. Remember to remove or replace sensitive data before uploading the file.
Trish in Oz
-------------
A problem well defined is a puzzle half solved
If you attach a sample of your workbook it will be easier to find a solution.Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
http://www.excelforum.com/faq.php?fa...b3_attachments
thanks for the response.. PFA sample document
Your pivot table does include all data from the dump tab. I have added a count field so you can see in the total that it refers to 7,319 records.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks