use expression to achieve 'cross table' effect on object
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?