<p>Hey everyone,</p>
<p> </p>
<p>I'm working on a BIRT Report where I have a DataSet from a FlatFileSource (.csv) which looks like:</p>
<p> </p>
<p>Source, Timestamp, Value</p>
<p>S1, 01-01-2015 00:00:00, 10</p>
<p>S1, 01-01-2015 00:05:00, 12</p>
<p>S1, 01-01-2015 00:10:00, 5</p>
<p>S1, 01-01-2015 00:15:00, 7</p>
<p>S2, 01-01-2015 00:00:00, 30</p>
<p>S2, 01-01-2015 00:05:00, 25</p>
<p>S2, 01-01-2015 00:10:00, 32</p>
<p>S2, 01-01-2015 00:15:00, 17</p>
<p> </p>
<p>The DataSet looks the same as the csv file</p>
<p> </p>
<p>Source Timestamp Value</p>
<p>S1 01-01-2015 00:00:00 10</p>
<p>S1 01-01-2015 00:05:00 12</p>
<p>S1 01-01-2015 00:10:00 5</p>
<p>S1 01-01-2015 00:15:00 7</p>
<p>S2 01-01-2015 00:00:00 30</p>
<p>S2 01-01-2015 00:05:00 25</p>
<p>S2 01-01-2015 00:10:00 32</p>
<p>S2 01-01-2015 00:15:00 17</p>
<p> </p>
<p>I want to sort the values in a descending order separated by the Sources and count the rows preparing the data for comparing them in a line chart. My idea was to create a table which looks like this:</p>
<p> </p>
<p>Row count Source_1_Value Source_2_Value</p>
<p>1 12 32</p>
<p>2 10 30</p>
<p>3 7 25</p>
<p>4 5 17</p>
<p> </p>
<p>an bind this table to a line chart with two series. The problem is getting this kind of sorting and filtering by column in the table. Can anyone please help?</p>
<p> </p>
