Pivot table

V

Vinit

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
 
B

Bernie Deitrick

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average of Subtotals in Pivot Table 0
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Problem with pivot tables 1
Link Drop Down with Pivot Table 2
Pivot Table Field based on two data area fields 3
Pivot table data source 1
Pivot Tables by Macro 2
Pivot Tables - Sum then Average 1

Top