Getting Started with Data

[User (Legacy)]

I have the data stored in a sql database table and want to display the 

following in a bar graph or similar with the major filter being the 

publicationID column

(X-AXIS) DISTINCT Pages for that publication

(Y-AXIS) SUM OF "Revenue" column for that page

(Y-AXIS) SUM OF "CMS" column for that page

this would them update as revenue/cms and pages were added with the same 

publicationID column

TO CLARIFY, publicationID, Page, Revenue, CMS are all columns in 1 SQL 

table.

[Software FX]

Chart FX will take a dataset, so all SUMs or DISTINCT operations need to be 

performed in your SQL Statement.

It looks like what you want is a two series chart: Revenue and CMS and 

Labels in the X'Axis corresponding to Pages.

Please refer to the programmer
Attachments.zip