sorting pivot2/clickable URLs by the clickable value displayed and not the URL itself | Help and How-To

bminehart · 2024-09-24T20:49:46.339000Z

When I have converted a pivot table column to have clickable link functionality, I cannot sort by the clickable displayed value. Instead, sorting is done alphabetically using the URL of the link, which is non-sensical for our use case.See example attached image. In the picture, the column has been sorted, but you can that the values displayed are not ordered properly because the rows were sorted according to the underlying URL.Example, the underlying value in the first row pictured is: <a href="https://url">202404605</a>. I want the table to sort by the 202404605 contained inside the HTML markup.

MoreDiscussions

sorting pivot2/clickable URLs by the clickable value displayed and not the URL itself | Help and How-To | Sisense Community