| Absolute Newbie [message #216192] |
Thu, 25 January 2007 08:54  |
Btibert3
Messages: 1
Registered: January 2007
|
Junior Member |
|
|
Hi Everyone,
By no means am I a database person; everything I have learned has been self taught for I have no formal training. We currently use Discoverer to extract information from our Oracle 10g warehouse. I have previously used other methods to create my reports, but am giving Discoverer a shot.
Where I am getting stuck is that I want to create, what I believe, is a basic table. I want my table to have the Year in the column (the data for the year is contained in my variable Year), and for my rows, I want a few variables (gender, race, etc.) I absolutely do not want my row variables embedded with each other, I simply want them stacked. For each row variable I want a total (it should be the same for each, of course). Finally, for the column, I want my counts by year, then next to it, I want the column % (60/40 M:F) for the year.
I have no idea how to do this. When I add additional variables to either the row or column, it wants to embed everything. Right now, as a way to get around this, I have created calculations for every category of the variables that I want, including the years. After getting halfway through, I realize that there probably is a good explanation of why it wants to embed everything and that column %'s are not capable.
Obviously any light you can shine on this matter I would greatly appreciate it.
Many thanks in advance,
~ Brock
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
