4 Replies Latest reply: Oct 9, 2013 5:51 AM by adeel ahmed

# Calculate Previous Record

Hi,

We have following data

 Customer MeterNo Month Reading Customer A Meter1 Jan-13 1521 Customer A Meter1 Feb-13 1820 Customer A Meter1 Mar-13 1989 Customer A Meter2 Jan-13 32164 Customer A Meter2 Feb-13 32456 CustomerB Meter1 Jan-13 4454 CustomerB Meter1 Feb-13 4485 CustomerB Meter1 Mar-13 4565

we want to calculate total consumed units of the month Customer and meter wise

Any help..?

• ###### Re: Calculate Previous Record

Put it in Pivot table

• ###### Re: Calculate Previous Record

No idea what you actually want, but one of these probably gives the result you want.

Total per customer: sum(total <Customer> Reading)

Total per month: sum(total <Month> Reading)

Total per meter: sum(total <MeterNo> Reading)

Total per customer per meter: sum(total <Customer, MeterNo> Reading)

Total per customer per month: sum(total <Customer, Month> Reading)

Total per meter per month: sum(total <MeterNo,Month> Reading)

See attached example

• ###### Re: Calculate Previous Record

What do you mean by previous in your title .

plz explain .

• ###### Re: Calculate Previous Record

Thanks all.

But i solve this to my self by Previous function in script.