MrExcel Publishing
Your One Stop for Excel Tips & Solutions

pivot table formulas


Posted by Leon Deouell on June 11, 2001 4:59 PM

When making a pivot table, you can summarize the data by a number of preset functions in the PivoTable field dialog: sum, count, average, etc. Is it possible to use any other function (e.g., median) to summarize the data?


Posted by Mark W. on June 12, 2001 6:42 AM

No.