Is there a way to show on a single report the following:

Total amount is Column 1
X amount is Column 2.
Percent of X from Total amount is column 3.

X, Y, and Z items would make up total amount. Is this possible? All data can be found in one table.

Thanks,

Joe

Yes, its is possible

ROFL!!!

I concur with Nubi that it is possible. Research multi verb requests such as -

SUM field
BY sort1
PRINT field
BY sort1

T

this is what i was getting at- this is WebFOCUS 101 type of stuff..

i think this is the only way to learn, its much better working this stuff out than just being told an answer because that way when you have to do this again in the future you'll remember how you do it rather than remembner that the answer is in the forum somewhere....

use:

WF manuals
WF help file
WF search forum archives
experimentation

all should be available to you to support the training you had and is as much as anyone one else here has....

I support Nubi's anwer...
although it seems to be not so client friendly....

Joe: please post a bit more info, make an example of the report that is less puzzling and try to work out something based on the CAR database. That will help everybody to understand better what you'r up to...

i agree Frank that somtimes you 'have to be mean to be nice'

im just trying to 'help people help themselves' and rolling out all the cliches while im at it...

SET ASNAMES = ON
APP PATH ibisamp
TABLE FILE CAR
SUM SALES   AS TOTSALES
BY COUNTRY
SUM SALES COMPUTE SHARE/D4%=100*C2/C1;
BY COUNTRY BY CAR
END
-* C1 IS COLUMN 1; C2 IS COLUMN 2; Cnotation doesn't count BY fields.

i'm willing to give Joe a head start...
Its Labor Day and i'm WORKING!!!

quote:

Its Labor Day and i'm WORKING!!!

It has alwyas seemed a bit odd to me - labor day and NOT working ....
I mean, isn't that what labor stands for?

GamP,

You have to remember that Americans spell it wrong anyway

T

TonyA,

Just because we no longer want to look as if we are FRENCH with the way words are spelled, does not mean it is spelled wrong.

Robert,

I was "fishing" as it was only tongue in cheek to see what I could catch.

Look what I landed

T

American