charts with where field

PHPMaker General Discussion (PHPMaker)
1

hy im have table.
Invoice Month Company/Type
109091 Jan AAN
30000 Jan JV
85455 Feb AANclor white COMPANY AAN
COLOr blue comapny JV
8000 |
7000 | | |
| | | | |
| | | | |
|||||_______jan feb ------what tools can I use?
thanks

2

Create a view to consolidate the chart data, then use the view as the chart source. Read help file topic: Preparing Data for Reports

3

ok thanks.can make a chart with 2 categories (x).?
company AAN and JV

4

You may select a multi-series type, set the series type as “Series field” and set your company field as the series field.

5

ok thanksCan it be a hidden list table and only display charts?if possible, what settings should I use.
thanks

6

You may disable “Show report”, see the topic Table Setup in the help file.

7

ok thanks but series.
how to make a sequence.
for example.
jan feb mar …
I tried but the sequence is still feb jan …
Can it?

8

See the topic Chart Setup > Custom sort sequence in the help file.

9

who is create?
ex. Jan,Feb,Mar,…
is it like that?
thanks

10

ok thanks arbei…connect the chart that was able to add a line chart to another table, for example to add a target table.
table.
Invoice_Lines/Amount Month Company/Type
109091 Feb AAN
30000 Feb JV
CHARTS what I choose?
thanks