Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a straight table, which has so many expressions.
I want to sort the table always with one expression value.
How can i do that using macro or any other method?
i have prev and next button implemented. Clicking that some expressions will be shown and others will be hidden.
so i want to sort the table based on a single expression always, even if it is hidden also.
If a user has changed the sort by clicking some column, then click on next button should retain the sort order back to the previous sort order.
How can we do that?
Hi,
If you dont want user to double click and change the sort then you do following setting.
Go to Sort tab -> Uncheck the "Allow interactive sort".
This will not allow user to change the sort.
Regards,
Kaushik Solanki
Problem with macro is: when it is activated it takes the current 8th expression from the chart...
when you are hiding the expressions then it gives wrong sorting...
the only trick which is coming to my mind is...
lets say you are having exp1 on which you need to sort your table...
take exp1 2 times in your table... now you will get two colomns with same expression that is exp1.
now make the Text color white for one of the column and header lable a space.. so that one column should not be visible..
now use that column no in your macro....
HTH
Sushil
But I have around 120 expressions in a table, it keeps changing on clicking the next button,
so i cannot use that expression multiple times in the table.
I want to restrict the sort to use only the 1st "8th" expression as the sort order,
but in the above macro, it changes for the current "8th" expression.
And client requirement is, they should be able to sort every column manually, so i cannot restrict them from sorting manually. but i want the sort to retain even if they sort it manually on clicking a button.
Dear Surya,
Make some dummy data and create a sample app...
without seeing your application it is difficult to give exact solution...
HTh
Sushil
Sushil,
There are so many combinations for getting the data.
To prepare data itself it will take time and we are working now for a deliverable today.
so not able to prepare sample data now.
any screenshots.. to explain your required functionality?