Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
In Listbox Expression
Class(Price,1000)
what if the price is an expression - for example: sum(price) * 100/0.5 ?
can i still use it with Class() ?
RGds
Jim
Try
Class(Aggr(Sum(Price)*100/0.5,Price),1000,'Price')
Hi
Try this : class(((price, 1000)*100/0.5))
Hi Jim,
I have already replied in the below thread. Please avoid posting the same question multiple times.
i totally understand that. but i posted wrongly.