If I do that, then I have the issue that one of my columns is an accumulated rolling sum of another column, but when I make it a straight table, I fixes the sorting of the table so that I cannot sort by the columns I want. Instead, it just sorts by the name of the first dimension. Have you ever encountered this issue?
That was the reason I changed it to a pivot table, because somehow, that allowed me to sort by expression. The straight table seemed to ignore the sort expression, until i removed the accumulated sum column (its a "rangesum(above(sum(" method).