Count outside of pivot table

[erick-flores]

Hello all

I am trying to get the count from a field in a pivot table outside of
the pivot table. I already have the count in the PT but because it is
lots of data I do want to show the count at the top of my worksheet. I
tried doing the =G20188 (which is the totalcount field in my pivot
table) but of course when I refresh the data (and the data has
increase or decrease) my formula will not adjust, it will give me the
same value of cell G20188.

Any ideas?

Thanks

 

[Jim Thomlinson]

Look at GetPivotData formula. To that end type an = and then select the total
count. You should get a getpivotdata formula. If you don't then you need to
make a change that is described here...

http://www.contextures.com/xlPivot06.html

 

[erick-flores]

Thanks