Skip to Content
0
Former Member
Jan 03, 2008 at 02:30 PM

Data summarization, how is this possible?

22 Views

Post Author: duleepnagahawatte

CA Forum: General

I have a table, which has got 4 columns. Column 1 u2013 ID Column 2 u2013 Contract NO Column 3 u2013 Invoice dates for the next year Column 4 u2013 Invoice amount Here is a subset of data as Column 3 format is bit complicated ID Contract NO Invoice dates for the next year Invoice amount 1 1400-4 Jan 1 2008, April 1 2008, Jul 1 2008, 450.00 Oct 1 2008 450.00*Company invoice the relevant client on those dates There are about 200 contracts like this Now what I want is to calculate monthly income of the company according to invoice dates and the amount and then show that in a graph. How is this possible?