straight table

[#1]

I have a straight table which is having multiple dimensions and an expression.

I have sorted the rows based on expression. It opens another sheet when I click on a particular cell.

Along with this the order of rows also changes. Is there any way to avoid this(change in order of rows on selecting a cell)

[MK_QSL]

It would be better if you enclosed your sample apps.

[#3]

Thanks for the reply

I cannot attach my sample.

I think the question is clear enough. Please let me know if you need more details.

[kiranmanoharrode]

Hello Kavita,

Just check Field Level trigger (on Select) of your application.

Just click on the particular cell and check in current selection box, i.e. which field is getting selected

Go to settings>> Document properties >> Triggers >> Field Event Triggers >> check for the field which you have identified in Current selection box. 

Then manipulate triggers as per your requirement.

Regards
Kiran Rode

+91 8976977897

[Gysbert_Wassenaar]

Maybe. It sounds like you need to make the expression you sort on independent of the selection you make. See for example this discussion: List Box sorting based on Expression. Without looking at your document it's impossible to tell you what to do or if it is even possible at all.

[#6]

Here is a sample.

My requirement is :

Rows having |A_State-B_State| high value need to be displayed at the top(in descending order).

Whenever there are multiple rows with same value for |A_State-B_State|, then |A_City-B_City| needs to be considered in same way, where rows with |A_City-B_City| high value come before rows with |A_City-B_City| low value.

Please let me know ur inputs on this.