Vinit,

Yes. Just drag the button of interest onto the data area again, as many times as needed, and set
that instance to the desired value (count, average, max, min)

HTH,
Bernie
MS Excel MVP


"Vinit" wrote in message
...
Hi,

Can I use the same value from data range in the pivot table part from using
the count and average etc?

If yes how?

Please Help

thnks
Vinit