Bar Chart with Price range listbox

[jim_chan]

i have created a bar chart with price.  i want to create a listbox price range as a filter. Can anyone out there help help??

I need to have a price range

<1000

1001 - 2000

2001-3000

3001-5000

>5000

how can i do that? should i do it in back end script?

Rgds

Jim

[antoniotiman]

In Listbox Expression

Class(Price,1000)

[jim_chan]

what if the price is an expression - for example: sum(price) * 100/0.5 ?

can i still use it with Class() ?

RGds

Jim

[antoniotiman]

Try

Class(Aggr(Sum(Price)*100/0.5,Price),1000,'Price')

[#5]

Hi

Try this : class(((price, 1000)*100/0.5))

[tamilarasu]

Hi Jim,

I have already replied in the below thread. Please avoid posting the same question multiple times.

bar chart with price range list box

[jim_chan]

i totally understand that. but i posted wrongly.