WDarwin
New member
- Joined
- Jul 9, 2021
- Messages
- 1
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Excel 2016
Hello. When in Pivot table, I have 80K distinct data. How do I display and return all data when I select cell and do the SHOW DETAIL function? When I do, I just get 1000 rows of data in a separate worksheet and not the 80K. I get this output 'Data returned for Distinct Count of Name (First 1000 rows)." How do I display ALL rows? Any assistance is much appreciated. Thank you. W