Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..?
Thanks all.
But i solve this to my self by Previous function in script.
Put it in Pivot table
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
What do you mean by previous in your title .
plz explain .
Thanks all.
But i solve this to my self by Previous function in script.