Home » Developer & Programmer » Reports & Discoverer » Grouping Columns In Discoverer
Grouping Columns In Discoverer [message #332537] Tue, 08 July 2008 19:58 Go to next message
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 Go to previous message
skooman
Messages: 912
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


Previous Topic: assign value run time in reports
Next Topic: page issue
Goto Forum:
  


Current Time: Sun Dec 04 18:46:39 CST 2016

Total time taken to generate the page: 0.11300 seconds