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

Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Word VBA - Auto Populate Text on Dependent Drop Down Exit 1
Help with drop down selection and populating related data... 9
Cross reference drop down not activating 1
How to refresh drop-down list of pivot table 3
Pivot table drop downs stop working 0
Excel 2007 pivot table using analysis services cube as data source 0
Excel 2007 vlookup with Pivot table 0

Top