B
bridgesmj
Hi, I have a set of time-series waterlevel data, from which I wish to
extract the daily maxima and minima. I've had no problem doing this
using a PivotTable for each query (using two helper columns that
extract the months and day from the date column).
However I would like to do this using just one table, and to display
the results in two adjacent columns (headed Maxima and Minima). I've
tried adding the two fields to the DATA section of the diagram, but
this just produces the PivotTable to take up two rows per day rather
than to display the values adjacently!
Hope someone can help - cheers in advance.
Mark.
extract the daily maxima and minima. I've had no problem doing this
using a PivotTable for each query (using two helper columns that
extract the months and day from the date column).
However I would like to do this using just one table, and to display
the results in two adjacent columns (headed Maxima and Minima). I've
tried adding the two fields to the DATA section of the diagram, but
this just produces the PivotTable to take up two rows per day rather
than to display the values adjacently!
Hope someone can help - cheers in advance.
Mark.