shasi.shekhar@gmail.com
New Member
Hi,
I have a data of Customers and their Monthly Invoicing details in MOM format as shown below. Now, I want to find their first month when they invoiced and also calculate their first six months of total business.
Data is as below for reference:-
Customer Jan/10 Feb/10 Mar/10 Apr/10 May/10 Jun/10 Jul/10
ABC 70.0 61.6
XYZ 63.9 64.1 79.9
ABC1 51.0 45.2
XYZ1 29.3
Thnaks in Advance for Help.
I have a data of Customers and their Monthly Invoicing details in MOM format as shown below. Now, I want to find their first month when they invoiced and also calculate their first six months of total business.
Data is as below for reference:-
Customer Jan/10 Feb/10 Mar/10 Apr/10 May/10 Jun/10 Jul/10
ABC 70.0 61.6
XYZ 63.9 64.1 79.9
ABC1 51.0 45.2
XYZ1 29.3
Thnaks in Advance for Help.