| Grouping Columns In Discoverer [message #332537] |
Tue, 08 July 2008 19:58  |
Viffer06
Messages: 3
Registered: July 2008
Location: Los Angeles, CA
|
Junior Member |
|
|
I have a report that have columns for each category. I'm trying to combine 3 categories and leave the remaining categories as separate columns.
Sample: Group Columns 1,2,&3 then SUM their totals,
Group 4 and Group 5 are separate.
How Can I do this in Discoverer?
|
|
|
|
| Re: Grouping Columns In Discoverer [message #332573 is a reply to message #332537] |
Wed, 09 July 2008 01:04  |
skooman
Messages: 913
Registered: March 2005
Location: Netherlands
|
Senior Member |
|
|
Add another (calculated) column containing some id (or other value) that shows how to group, for example:
group_id category value
A 1 xx
A 2 xx
A 3 xx
SUM group_id A xx
4 4 xx
5 5 xx
GRAND TOTAL xx
So, the group_id for categories 4 and 5 in this example is meaningless, but it enables you to choose categories you like to group together.
(at the aggregate defintion, choose "hide single row totals" or what's the name exactly in order to have no separate sums for categorie 4 and 5)
The calculation of column group_id would be something like:
CASE WHEN category in (1,2,3) THEN A ELSE category END
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
