pivot table

  • Thread starter Thread starter Franci
  • Start date Start date
F

Franci

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?
 
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(...))
 
That works. Thank you!

Jim Thomlinson said:
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(...))
Click to expand...
 
Back
Top