Hi, I have a scenario where non-numeric cross-tab would be ideal. However, I seems that BIRT errors out when trying to render non-numerics. Anyone knows how to get around this problem?
Thanks,
If there are Accepted Answers, those will be shown by default. You can switch to 'All Replies' by selecting the tab below.
Check out the attached example. Note that the cells of the crosstab aggregate multiple rows of data. If the data is a string, you can't just sum the values. You have to tell the crosstab which value to display. In the example, I specified that the crosstab will display the value from the first row of data for the cell. To see this, edit the "status" summary field in the Data Cube. The "First" function is selected.
Thank you, Jeff!
I used FIRST as an aggregate and it worked. Thanks so much!!
@jfranken said: Check out the attached example. Note that the cells of the crosstab aggregate multiple rows of data. If the data is a string, you can't just sum the values. You have to tell the crosstab which value to display. In the example, I specified that the crosstab will display the value from the first row of data for the cell. To see this, edit the "status" summary field in the Data Cube. The "First" function is selected.
