Forum Discussion
wshalex123
3 years agoHelper III
Measure expression
Hi, i got a calculated table which shows the next jubilees of my employees: When creating a table visual it looks like this: Note: I created seperate columns for the strings like "...
Greg_Deckler
3 years agoCommunity Champion
wshalex123 What are you not happy with in terms of the order in the table visual? You can change the sorting using the ellipses and you can use Sort By columns as well to modify the order.
- wshalex1233 years agoHelper III
Hi Greg,
the order of the columns is correct and i know how to sort them of course.
I just want the result to be a "whole" sentence with the same space between all values.
- Greg_Deckler3 years agoCommunity Champion
wshalex123 CONCATENATEX
- wshalex1233 years agoHelper III
Greg_Deckler
I tried to change it to your suggested formula. When leaving the "order by expression" gone, i shows me a whole sentence of both entries combined.I would like to have both entries in different rows. i tried it with the "order by expression" but it shows me following error: