Forum Discussion
sort multiple columns
The order you have the columns will impact the sort on the table. Using the col1, col2, col 3 example a table with col1, col2, col3 will show differently to col3, col1, col2.
Alternatively, if you put your ranking/sorting caculated field at the start of the table and then use the 'Field Formatting' option you can set text and background to white (or a colour matching your report back groud) and apply to header, values and total this will effectively hide the column (you can also make this narrow in width by ensuring auto size column is off under column headers).
I am not sure sorting col1 (for example) on your calculated field as a value in col1 may have two different sort values due to col2 and col3 values and the sort option needs a one-to-one match (hope that makes sense)
I have tried this workarround, Looks good. But on hover on cells it feels like some information is missing, and tooltip renders the value of that cell. I am trying to hide columns by making width narrow but still hover reveles tooltip.