Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table
example of fields in my data table:
Legal Acres Expiration 1-1N-5W 50 8/9/2009 1-1N-5W 20 9/9/2009 1-1N-5W 10 10/9/2009 My pivot table shows the total acres per legal and but I don't know how to show the earliest expiration date per legal. Any ideas? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table
Depends how you want to aggregate. If you want the total acres of all
recordsand the Min date then it is fairly easy. Add the Date field to the data section and select Min as the aggregation type. If you want to only aggreaget the min values then you need to add a field to your source data to flag the min of each legal. Not too bad with an array formula =min(if(...)) -- HTH... Jim Thomlinson "Franci" wrote: example of fields in my data table: Legal Acres Expiration 1-1N-5W 50 8/9/2009 1-1N-5W 20 9/9/2009 1-1N-5W 10 10/9/2009 My pivot table shows the total acres per legal and but I don't know how to show the earliest expiration date per legal. Any ideas? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table
That works. Thank you! "Jim Thomlinson" wrote: Depends how you want to aggregate. If you want the total acres of all recordsand the Min date then it is fairly easy. Add the Date field to the data section and select Min as the aggregation type. If you want to only aggreaget the min values then you need to add a field to your source data to flag the min of each legal. Not too bad with an array formula =min(if(...)) -- HTH... Jim Thomlinson "Franci" wrote: example of fields in my data table: Legal Acres Expiration 1-1N-5W 50 8/9/2009 1-1N-5W 20 9/9/2009 1-1N-5W 10 10/9/2009 My pivot table shows the total acres per legal and but I don't know how to show the earliest expiration date per legal. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Pivot Table and Pivot Table dates are not in correct order | Charts and Charting in Excel | |||
Print Pivot Table headers on pages with Pivot Table | Excel Worksheet Functions | |||
Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions | |||
How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel |