How to write Greater than symbol in set analysis

[timanshu]

I have a table with bucket field and sales field ->

Bucket    Sales

10-20     100

20-40      30

40-50      50

>50         120

I want to show sale of only >50 in a chart through set analysis. How can I do. Since writing > in set analysis , >50 as whole is not considered as a field value.

Please help.

[arvind_patil]

Or else Provide sample app.

[vinieme12]

Try

=sum({<Bucket={'%50'}> }  Sales)

or

=sum({<Bucket={$('>50')}> }  Sales)

[timanshu]

Script Generated field.

[timanshu]

Thanks. But I want to get rid of creating new field.

[bharani8]

Then in ur Bucket.. instead of ">50".. Use "Greater than 50"

[Anil_Babu_Samineni]

May be share Excel data? I thought you created Bucket Field In script.

[tresesco]

Then I guess, Sales is also coming aggregated from script. If so, you may try like:

=sum({<Sales={">50"}> }  Sales)

Or,

=sum({<Bucket={"=Sum(Sales)>50"}> }  Sales)

[arasaraja_cts]

Hi ,

PFA .

Thanks

Raja