Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Tables - How do I add Functions as a Calculated Field?
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 -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200604/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pb with calculated field in a pivot table | Excel Discussion (Misc queries) | |||
Calculated field in Pivot Table | Excel Discussion (Misc queries) | |||
% of calculated field in pivot table | Excel Worksheet Functions | |||
Multiple Pivot Tables with single Page Field | Excel Discussion (Misc queries) | |||
How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) |