Table total column SUM with filter

Col1

1
2
3
4
5
6
7
--
28 -- Total

with filter col1 >= 5

Col1

5
6
7
--
18 -- Total [while expecting Total 28, for all col1 numbers]

in both case i want to show same Total in footer even Filter is showing particular numbers

Any suggestions?

Thanks

Find more posts tagged with

Comments

mwilliams

Hi mh10,

So, you want to show 28, in this case, no matter what? What is the data like in the dataSet? Could you make a computed column that sums the data in the dataSet and then just use that value in the footer?

mh10

computed column worked...thanks 
 
 
<blockquote class='ipsBlockquote' data-author="mwilliams">Hi mh10, 
 
So, you want to show 28, in this case, no matter what? What is the data like in the dataSet? Could you make a computed column that sums the data in the dataSet and then just use that value in the footer?</blockquote>

mwilliams

Excellent! Glad to help.

kevin23_hy

hi,willams:
i got same doubt that add a computed column with Filter,expression is row[columnNameID] = 2 but cannot show out.but add dataSet's Filters can work.
so what difference between those and what's wrong in computed column filter. i used birt2.3.1 integreated in MyEclipse7.x.
thx advance for reply.

mwilliams

Hi kevin23_hy,

Could you explain your issue a little more? I'm not sure I'm understanding correctly. Thanks.

kevin23_hy

o,i just wanna clear what difference between DataSet's Filter(Filters) and computed column's filter(Filter). Why Filter cannot work with expressions but Filters can. A pic in the attachment you can see.