Set up a pivot table with Name and Meter Number in the row area, Date in
the column area, and Reading in the data area.
Drag another copy of Date to the data area
Right-click on the Date heading in the data area
Choose Field Settings
Click the Options button
From the 'Show data as' dropdown, choose 'Difference from'
For the base field, select Date.
For the base item, select (previous)
Click OK
Right-click on the Reading heading in the data area
Choose Field Settings
Click the Options button
From the 'Show data as' dropdown, choose 'Difference from'
For the base field, select Date.
For the base item, select (previous)
Click OK
Peter Hindley wrote:
This may sound like an easy question but it has been
puzzling me for days!!
Any Help on this would be great
3 meter numbers, All different readings taken on
different dates. On each visit all 3 are read. I would
like to be able to have a pivot table where the
difference between the readings taken is shown. Based on
chronological order following the date read column to
sort by.
My data will look like this -
Column A Column B Column C Column D
Little Richard SP C61L 00578 15/12/2004 63587
Little Richard SP C66L 12364 15/12/2004 63033
Little Richard SP C66L 09812 15/12/2004 95529
Little Richard SP C61L 00578 15/01/2004 63597
Little Richard SP C66L 12364 15/01/2004 63061
Little Richard SP C66L 09812 15/01/2004 95568
Little Richard SP C61L 00578 15/02/2004 63647
Little Richard SP C66L 12364 15/02/2004 63172
Little Richard SP C66L 09812 15/02/2004 95754
I need the output of days difference between readings on
each meter. And a total difference between the current
and last reading for the corresponding meter number.
So for the above I would like to show 31 days for the
difference on all meter numbers and then for each meter
number a difference of
C61L 00578 - 10
C66L 12364 - 28
C66L 09812 - 39
C61L 00578 - 50
Etc..
Then to calculate the amount used per day for each meter
number
Peter
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html