Forum Discussion
pfarahani
Helper II
5 years agoMisery
Hi All, I have this syntax that creates a table, it works. How can I add a Order by. I want to Order by Alpha, and NumValue. Thanks Department – Slicer = CALCULATETABLE ( ADDCOLUMNS ( SUMMA...
Greg_Deckler
Community Champion
5 years agopfarahani I agree with Calvin69. I will add that you could create an additional column in your ADDCOLUMUS function that simply concatenates Alpha and NumValue using the & operator. You can add this to visuals, turn off word wrap and shrink the column width in the visual to hide it in table or matrix visuals . Then you can sort by it in the visual and nobody knows it's there.