Help Please! - Creating Function Calculated Fields within Pivot Tables

C

ColinS

I would greatly appreciate any help on this, as I spent yesterday afternoon
on this!

I have created a sizeable Pivot Table in Excel 2003 for some analysis that I
am working on. I would like to add in to my Pivot Table a calculated field
that uses the functions suite available through Excel generally, such as
Lower Quartile, Upper Quartile etc.

I can add in calculated fields for very basic processes, such as multiply,
divide etc., however, when I add in the formula for say Lower Quartile, it
doesn't seem to work. It does seem to go through the process of adding the
new Field to the Field Listing, but this doesn't actually calculate the Lower
Quartile (it actually seems to provide a 'Sum of' calculation that I cannot
alter via the Field Settings.

The formula that I have been using is as follows. I have also tried numerous
variations of this equation.

=Quartile('Field Name',1)

My questions:

1. Can you add functions via the Calculated Fields to a Pivot Table?
2. If so, what is the correct procedure for doing this? Am I using an
incorrect formula?

Many thanks, Colin
 

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

Top