Working with a file of 65mb - a bit over 317,000 rows. Trying to get some Pivot Table data, and three times it is coming up with different results as to the number of items being reported. (Working with a 'Merch Number' - there are 1667 unique ones after removing duplicates, but the Pivot Table results are only showing 319, or 830, etc.
Is there an inherent limitation for Pivot Tables to work based on number of rows?
Is there an inherent limitation for Pivot Tables to work based on number of rows?