Formulas available in pivot table and grouping drop-down menus

D

Deb C

Does anyone know if I can customize excel to offer me other formulas when
creating a pivot table or using the grouping function? I'm referring to the
drop down list where you choose a formula and would like to be able to add
median to the list.
 
S

Shane Devenshire

Hi,

The answer is no, unfortunately. You can create your own formulas under
PivotTable, Formulas, Calculated Fields or Calculated Items. However, be
extremely careful when you use these, check the results to make sure they
calculate what you want. Because of the way Microsoft has set up this area
you can not get a meaningful result from a MEDIAN formula. It will return a
result but it will be incorrect.

If this helps, please click the Yes button.

Cheers,
Shane Devenshire
 

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

Change quarters in Pivot table when grouping 1
Grouping by month in a Pivot Table 1
How to refresh drop-down list of pivot table 3
Pivot Table Drop Downs 3
Pivot Table criteria 2
grouping in pivot tables 2
Pivot table drop downs not refreshing 1
Pivot Table group levels 3

Top