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

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
--
HTH...

Jim Thomlinson


"erick-flores" wrote:

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

Thanks