CODEWITHSUNDEEP
pentahodashboardkettle
Kal
Kal

Reputation: 323

Pentaho CDE Table Component

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.

Upvotes: 0

Views: 3887

Answers (1)

nsousa
nsousa

Reputation: 4544

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.

Upvotes: 1

Related Questions