problem in table

[#1]

Hello

I am working with a straight table which has a column of sum of sales. Now the requirement is to add a column sum(sales) with condition on another column which is Revenue.so it should be sum(sales) if rev>0.

I added both the columns but both were giving the same result, which I thought was fine, but for a particular bill that was not true so  I added the dimension 'bill' to the table and chose the option sum of rows on conditional sum of sales column. That gives the perfect answer to the solution.  BUT the problem is neither I can have dimension 'bill' in my table nor the straight table. and if i remove the dimension bill it gives the same sum of sales for both columns.

So is this possible that adding a dimension can alter the result of expression. how to deal with this. please help

Thanks in advance

[settu_periasamy]

May be try with aggregation, like

=aggr (sum (sales),bill)

[#3]

I tried this, but for this I willl have to add bill as dimension in my table, which is not required

[#4]

Can you please share sample QVW for reference or at least temp data?

[trdandamudi]

May be this...

=Sum({<rev={">0"}>} Sales)

[#6]

yes I tried this but when I add dimension bill to this table it alter the result. then it shows different sum

[settu_periasamy]

Can you share the sample?