Forum Discussion
sort multiple columns
HI, I am rendring Table visual, Here I want to sort rows based on three columns, But currently sorting with multiple column is not available. So i tried to concatinate all three columns & created a ...
Hi Sumant,
Here is one of the workarounds -
Suppose the columns are col1, col2, col3 and your calculated column is col4.
Bring col1, col2, col3 in your table.
In the right hand side panel, click (select) on the field (either of col1, col2, col3) based on which sorting is to be done.
Go to Modelling tab in the top ribbon - Sort by column option - select the calculated column col4.
Hope this works for you!
I have tried creating col4 with my required Order, and from Modeling tabin top ribbon - Sort by column option selected col4. in Table visual its still not working. In Case i am keeping Col4 in my table visual & applying sorting from there its working. But as per my requirement i dont have to render col4 in table visual.