Home > database >  Customer number, customer name, contract number, amount receivable, paid-in amount request chart, in
Customer number, customer name, contract number, amount receivable, paid-in amount request chart, in

Time:09-22

The customer number, customer name, contract number, amount receivable, paid-in amount
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 of

CodePudding 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, quantity
Such 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
  • Related