C
ColinS via OfficeKB.com
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
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