Requirements
Line graph, the statistical figure shows a receivable amount, the same customer accounts receivable amount
In time, for the horizontal axis,
CodePudding user response:
Is the sum on the group by?CodePudding user response:
In a statistical figure shows the same customer amount receivable, accounts receivable amount of comparison and analysis ofCodePudding user response:
Pb have the graph can be implemented, as long as you put the data the whole reasonable,CodePudding user response:
Table main columns: customer number, customer name, date, type, quantitySuch as:
C001 client 1 2012-06-09 contract number 3
C001 1 2012-06-09 customer accounts receivable amount 54321
C001 customer 1 2012-06-09 paid-in amount 12345
(a client on the date, there are three data, respectively is shown: the contract number, amount receivable, paid-in amount)
Graph with dw window, select series: type, the value is: number, the date categories as:
You can come out,
So, as long as the control dw data window, you can control, contract number, whether need to display, make a filter to da, setfilter (" type & lt;> 'the contract number ")
They only the accounts receivable and the amount in the graph,
CodePudding user response:
If need practical help, next Monday to go to work, contact again