T
TonyL
I have a database of over 300K records. I have 1 field called region. I am
trying to do a pivot table where it totals every region using the count
function. Not all of the regions are showing in the pivot table & I checked
the total for 1 region which had a count of 29 in the pivot table but I
counted over 2500 in the database. As the database has over 300k records, is
there a limit to the size of the database on what the pivot table can do? I
am not using any filters. TIA
trying to do a pivot table where it totals every region using the count
function. Not all of the regions are showing in the pivot table & I checked
the total for 1 region which had a count of 29 in the pivot table but I
counted over 2500 in the database. As the database has over 300k records, is
there a limit to the size of the database on what the pivot table can do? I
am not using any filters. TIA