I need to show start date and end date along with final reading and initial reading of the month? please help

Hi Surya,

Find my approach as reference & starter stored in attached workbook version 10.5 located in the original thread.

1. D1. Interval TimeStamp (Month / Year):

2. M1.  Initial Reading of the month: if {fixed [Meter S No],[D1. Interval TimeStamp (Month / Year)]:min([Interval TimeStamp])}=[Interval TimeStamp] then {fixed [Meter S No],[Interval TimeStamp]:sum([Cum kWh])} END

3. M2. Final Reading of the month: if {fixed [Meter S No],[D1. Interval TimeStamp (Month / Year)]:max([Interval TimeStamp])}=[Interval TimeStamp] then {fixed [Meter S No],[Interval TimeStamp]:sum([Cum kWh])} END

4. M3. Delta: sum([M2. Final Reading of the month])-sum([M1.  Initial Reading of the month])

Regards,

Norbert