Need to display same data twice in the same table with some filtering

ngocvdoan

Hi,

I have a table that binds to one dataset. Inside the table, I inserted a group on EmpID.
Now on the first row, I want to display all the records where EmpID = 103 and do the aggregation sum on their salary and display the Total below it.

On the second row(same table), I want to display all the records where EmpID <>103 and do the aggregation sum on their salary and display right below it.

This is kind of a filtering but is there a way I can do this within one table one dataset? Or do I need to create a second dataset and then insert the second table inside the first table to accomplish what I need?

Please let me know I would appreciated.

Thanks.

Hans_vd

Hi,<br />
<br />
You could create a computed column in the data set like this:<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>if (row["EmpID"]==103) {
return 0;
}
else {
return 1;
}</pre>
<br />
and then in the table create a grouping on the computed column.