LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 176
Default Can I calculate quartiles in an Excel 2007 pivot table?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to create pivot table from existing pivot table in excel 2007 Udayraj Dhulekar Excel Discussion (Misc queries) 2 July 8th 13 08:22 PM
Excel 2007 pivot table source table sb Excel Discussion (Misc queries) 1 August 21st 09 12:18 AM
Pivot Table in Excel 2007 : Problem with % in Table spudsnruf Excel Discussion (Misc queries) 2 January 9th 08 09:53 PM
Computing Quartiles with Excel 2007 Quco Excel Discussion (Misc queries) 3 March 19th 07 07:20 PM
Calculate Formulas in Excel 2000 Pivot Table Christina Excel Discussion (Misc queries) 0 January 11th 07 05:10 PM


All times are GMT +1. The time now is 05:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"