Reply to thread

Message: [QUOTE="Debra Dalgleish, post: 5992513"] 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 [/QUOTE]