sorting of data

[SunilChauhan]

Dear alll

i have data like

product quantity price frequency

Tea 100 200 4

coffee 100 300 -

Sugar 300 - -

milk 400 200 6

hot water 500 4000 -

xyx 500 - -

i want to sort this like

product quantity price frequency

Tea 100 200 4

milk 400 200 6

Sugar 300 - -

xyx 500 - -

coffee 100 300 -

hot water 500 4000 -

please help me

Regards

Tom

[#2]

You could create another column(called sort) and put your sort criteria in there.

[#3]

Hello Tom,

I suppose you want to use frequency as a sorting column. It seems to that your '-' does not represent a null-value. If the empty rows are loaded with the null() it should work as you expect it.

load .... if (len(frequency) >0, frequency, null()) as frequency; ...

Regards, Roland

[SunilChauhan]

hi roland,

thanks for your kind reply.frequency is acually in cycle drill down and its not working to me.

please suggest me.

thanks

Tom

[#5]

HI Tom,

try this,

Create a new table using inline wizard

Product SortOrder

Tea 1

milk 2

Sugar 3

xyx 4

coffee 5

hot water 6

after reload, Document Properties ->Groups->Cyclic Group -----> click on sort order button which is in bottom right hand side.

In Sort by column -> use SortOrder field as expression.

Regards,

Prabhu

[#6]

Hello Tom,

I created I sample application with your data. Sorting of a column is independent of being in a group. And I think you don't want to sort allways in the same order (as i.e. posted above). Would you please try to describe it exactly in my app?

RR

[#7]

Hi Tom,

Here with I have attached the application in which way you want.Check and let me know.

Thanks & Regards

Jai

[SunilChauhan]

Dear jay ,

thanks for ur reply.

i have more products and i can give seq like this.

if u have any idea then let me know.