| Horizontal Across Aggregation in Report [message #78299] |
Sun, 02 October 2005 17:02  |
Eclipse User |
|
|
|
Originally posted by: wim.goffin.telenet.be
I need to create a report where the data are aggregated in two dimensions:
1) horizontally, with the totals calculated on the right side of the rows,
and
2) vertically, with totals at the bottom of the columns.
The records selected from the database have a structure (dimension1 value,
dimension2 value, numericeal value)
Is this possible with Birt and how can I do this?
Thanks in advance,
Wim
|
|
|
|
| Re: Horizontal Across Aggregation in Report [message #78895 is a reply to message #78773] |
Tue, 04 October 2005 09:37  |
| Eclipse User |
|
|
|
Wim,
I think that it is. I would define a CrossTab as a report in which both
the rows and the columns can grow. Imagine that we have a company
selling products in a number of cities. A crosstab report of that data
would be one that shows
City1 City2 City3 City N Total Per
Product
Product 1 $10 $8 $7 $6 $31
Product 2 $11 $9 $6 $5 $31
Product 3 $12 $7 $5 $4 $28
Product N $13 $6 $4 $3 $26
Total per City $46 $30 $22 $18 $116
Where the N column or the N row could repeat an unlimited number of times.
One of the issues is how to deal with columns that grow past the width
of the page.
Scott Rosenbaum
BIRT PMC
Wim Goffin wrote:
> Could someone define the word crosstab?
> Would it be the feature I described in my previous question in this
> thread?
>
> Thanks in advance,
> Wim
>
|
|
|
Powered by
FUDForum. Page generated in 0.04197 seconds
Home