G Graeme Williams Nov 2, 2009 #1 When I build a pivot table, I can use the sum, average, minimum or maximum of the data values. Can I use quartiles as well?
When I build a pivot table, I can use the sum, average, minimum or maximum of the data values. Can I use quartiles as well?
P pshepard Nov 4, 2009 #2 Hi Graeme, Unfortunately Quartile is not a summary option for pivot tables, nor is median. However there is a worksheet function: =QUARTILE(A:A,2) which is the same as =MEDIAN(A:A) Hope this helps. PShepard
Hi Graeme, Unfortunately Quartile is not a summary option for pivot tables, nor is median. However there is a worksheet function: =QUARTILE(A:A,2) which is the same as =MEDIAN(A:A) Hope this helps. PShepard
J John Calder Nov 4, 2009 #3 I am no expert but you can create "helper" columns in your database that calculates your quarterly figures then use these in a new pivot table. or You can create formulas within the pivot table to add together the data you need (depends on how your data is contructed) or you can add a date range to you pivot table that allows you to select data between 2 different dates. http://www.contextures.com/excelfiles.html#Pivot I use this all the time for my pivot table.....its great. Cheers John
I am no expert but you can create "helper" columns in your database that calculates your quarterly figures then use these in a new pivot table. or You can create formulas within the pivot table to add together the data you need (depends on how your data is contructed) or you can add a date range to you pivot table that allows you to select data between 2 different dates. http://www.contextures.com/excelfiles.html#Pivot I use this all the time for my pivot table.....its great. Cheers John
