ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Pivot table (https://www.excelbanter.com/excel-worksheet-functions/248997-pivot-table.html)

Vinit

Pivot table
 
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

Bernie Deitrick

Pivot table
 
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





All times are GMT +1. The time now is 05:09 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com