I'' try to describe what I want...wish I could just post a picture!

I have 3 fields:
DEPT
YEAR
PMTS

I have a report that shows DEPT as rows and YEAR as columns. Under each year are the PMTS for the DEPT found on that row. Great!

They then wanted to know what the % of the total was represented by teh PMTS. I simply added line of code something like: PCT.PMTS.
Easy!

Example, the report might show for example that Dept: 100A had 20K in payments in 2015 and that was 20% of the payments for all departments for that year.
Great - works fine!


Next up they wanted a *separate* graph for each DEPT showing PMTS by YEAR. I used a multigraph...

For example, they can now graphically see, that DEPT 100A's payments rose from 10K in 2013 to 15K in 2014 to 20K in 2015. Alongside that might be another graph showing DEPT 100B trending downward over the past few years. All works fine, no problems!


Now they want another set of graphs, again multi graphs by YEAR, one graph for each DEPT but this time showing the % the PMTs were of the total payments for all deptartments for that year.

Is there a way I can do this with these 3 fields and the graphing GUI in WF 8008????

To be more specific, if DEPTA comprised 20% of all payments in 2013 and 25% in 2014 and 17% of all payments in 2015, when looking at the multigrpah for DEPT 100A, I would see these percentages (20%, 25% and 17%) plotted against each other.

I have no idea where to start!

This message has been edited. Last edited by: RobertF,

Could you post an image of an Excel spreadsheet that mimics this? You can store the image in the public folder of your dropbox account, or some other file hosting site. Then add an image link here referencing the file.

probably quicker this way...but uglier..if I get a chance I'll try to get a pic...



...........2014....2014...2015...2015
DEPT.......PMTS....%......PMTS.....%
100A.......1000....10%....2000....20%
200B.......2000....20%....1000....10%
300C.......7000....70%....7000....70%
TOTAL.....10000...100%...10000....100%



The report sort of looks like this. The same three fields render the current multi graphs, thus there are 3 bar graphs plotting DEP100A's total payments by year (1000 vs 2000), DEPT200B's total payments by year (2000 vs 1000) etc.

Now they just want the same bar graphs but with the percentages plotted....DEPT100A(10% vs 20%) etc.

Of course we have more depts and years.

Something like this???

I cant view what you posted.


I'd guess the code would have to look like a report that groups by year and prints the detail payment and % payments by DEPT where the % is the % of the YEAR subtotal...whatever that looks like...

Well, this sort of illustrates what I am trying to do with the CAR file. Why the CAR data does not have a Month or Year in there bewilders me but I will use county in its place.

If you run this you will see County / Model and sales, subtotaled on Country. Note the % of the model's sales for the country.

What I want to graph is each of the Model %'s exactly as seen but by Country. I can not get it to work. I am guessing I must make a HOLD first then do my graph off that. If I am wrong let me know...


TABLE FILE CAR
SUM
CAR.BODY.SALES
PCT.CAR.BODY.SALES WITHIN COUNTRY
BY LOWEST CAR.ORIGIN.COUNTRY
BY LOWEST CAR.CARREC.MODEL

ON CAR.ORIGIN.COUNTRY SUBTOTAL AS '*TOTAL'
ON TABLE SUBFOOT
""
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE COLUMN-TOTAL AS 'TOTAL'
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
ENDSTYLE
END

This message has been edited. Last edited by: RobertF,