| Can cross tab be used to create a Pivot table (BIRT 2.2)? [message #256866] |
Wed, 03 October 2007 06:52 |
Eclipse User |
|
|
|
I am using BIRT 2.2. and need to create a Pivot table. Can a cross tab be
used to create a Pivot table?
My data set has 4 columns: ReportMonth, OpenedCalls, ClosedCalls and
ActiveCalls.
Example:
ReportMonth OpenedCalls ClosedCalls ActiveCalls
------------------------------------------------------------ ----------
7/2007 311 301 21
8/2007 399 388 11
9/2007 401 396 17
.. .. .. ..
I quite like to a pivot table in my report based on the reportMonth.
Example:
7/2007 8/2007 9/2007 ..
----------------------------------------------------
Opened Calls 311 399 401 ..
Closed Calls 301 388 396 ..
Active Calls 21 11 17 ..
Following the tutorial I managed to create a cross tab, where the
reportMonth as headings by. (Created an Cube based on my data set and
defined a group/dimension with one dynamic level based on reportMonth).
However I cannot work out how to create my rows. Has anyone ever used
cross tab to create a simple Pivot table similar to the above?
Thanks,
Anette
|
|
|
Powered by
FUDForum. Page generated in 0.07694 seconds
Home