Straight Table Chart - Sorting

[#1]

All,

I am using a straight table chart with one dimension and multiple expressions that relates to that dimension.

(All these dimensions and expressions came out as a column for the table - which is fine for me)

No I want to sort the entire table based on a 'field' which is not part of the table that is formed but that is available in the list of 'fields' for me to add to the table.

[In short: I have A, B, C, D, E fields. I want to bring A, B, C, D  in the table and want to sort them based on 'E' field.]

Can someone help me how to do this?

Thanks in advance.

[swuehl]

Maybe chart properties - sort tab - sort by expression and enter the field name?

[#3]

Thanks, swuechi.

I tried this one previously also it seems like working fine. But when I do that it is missing some inbetween rows.

So, I thought that was wrong.

may be, that is the right direction and I am missing those rows because of someother other conditions.

[swuehl]

How does your field you want to sort by looks like? Does it have a value for each of your dimension values? And does it have the same value for same dimension value, if dimension value can appear multiple times in your table?

[#5]

It does have a unique value for each dimension values and I can clearly see some inbetween values are missing after loaded. Like 5001, 5003, 5004, 5007, 5010 etc...

[swuehl]

Sorting by this additional field does remove lines from your straight table?

Hm, can't think of a reason right now. Could you upload a small sample?

[#7]

Thanks swuehi.

I found the solution. Actually, I was trying to populate data with a dimension field which is not appropriate.

I tried using different dimension field, it worked perfectly.