Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 "Graeme Williams" wrote: 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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 pivot table source table | Excel Discussion (Misc queries) | |||
Pivot Table in Excel 2007 : Problem with % in Table | Excel Discussion (Misc queries) | |||
Computing Quartiles with Excel 2007 | Excel Discussion (Misc queries) | |||
Calculate Formulas in Excel 2000 Pivot Table | Excel Discussion (Misc queries) |