<p>Hi,</p>
<p> </p>
<p>I have a crosstab, and want a custom total column with last values. I have createad the grand total column and there i put the data i want. I have createad an aggregation with last as the function to aggregate. The problem is that it works great when there is data, but when there is a null value, i dont want the prior last data. I would rather put a 0. How can i simulate that if the last value is null, put a 0 in the custom grand total column. </p>
<p> </p>
<p>Like this is what shows</p>
<p> </p>
<p> Jan Feb Mar Apr Last</p>
<p>Rice null null 54 null 54</p>
<p>Oil 44 null 14 66 66</p>
<p>Salt 5 null null null 5</p>
<p> </p>
<p>But i want THIS output and dont know how to get it</p>
<p> </p>
<p> Jan Feb Mar Apr Last</p>
<p>Rice null null 54 null 0</p>
<p>Oil 44 null 14 66 66</p>
<p>Salt 5 null null null 0</p>
