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?

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?

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?