Pentaho CDE Table Component

Question

I got the following columns out of a query:

Year, Type, Value

I want a table showing how much value each year and type has. But the table Component in CDE puts Year and Type at the left, and then all values at the right.

How can I put Types at the top? So I get Years on the left column, Types on the top line, and the table showing the Values, like a crosstable. I don't see such configuration options in the table Component.

Answer 1

The table component gets you the data as it comes. Your data is not in crosstab form, so the table won't do it automatically.

You can either change your query to return 1 column per type (especially easy if you use MDX) or change your data structure in the postFetch of the component.