use expression to achieve 'cross table' effect on object

[yelin_nyu]

need to create a line chart with 3 different fields, I didn't want to use cross table to transform my tbl in back end, because out of 100 objects in the tool only 1 object looks at every months (the trend). the rest of 99 objects only cares about Jan. So changing to cross table means I have to add a set analysis on all those objects to look at month=jan only.

how do I create a trend of jan, feb, mar if all of them a separate field?

[yelin_nyu]

ok I found a stupid way to do this, making a data island: month, with values like jan, feb, mar

and create a line chart use month as dimension, and expression: if(month='jan', sum(jan), if(month='feb', sum(feb)...

it worked!!!! but is there better way to do this? like pick or any other function.

[jaimeaguilar · Accepted solution]

Hi,

In Properties > Presentation > there is a checkbox that says 'Horizontal'. If you activate it, you can visually traspose your table, so you can get a cross-table like effect,

check the attached example,

regards