The table display more then 100 row. I want to display those sales amount > 1000.

[paulyeo11]

HI All

I have a table which display

Dimension :-

COMPANY

date

Expression :-

Sum(if(Month_n='1',sales))/Rate

The table display more then 100 row.  I want to display those sales amount > 1000.

May i know how to do it ?

Paul Yeo

[paulyeo11]

My QVF !

[kaanerisen · Accepted solution]

Hi,

You can use this expression

sum(aggr(IF(Sum(if(Month_n='1',sales))/Rate>1000,Sum(if(Month_n='1',sales))/Rate),COMPANY,date))

and uncheck "Include zero velues" on Data handling menu of table properties.

Hope it helps.

[paulyeo11]

Apprecaite very much it work