Repeat row labels in dimensions in pivot

[#1]

Hi,

I am having an issue where I am not able to repeat the row names of dimensions, so that it mentions each label multiple times in the dimension column.

Does anybody know how to do this?

Best regards,

Claus

[#2]

Changing the Pivot to a straight table should do the trick...

[#3]

Hi Pravesh,

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).

[#4]

Yeah, have come across this before. Have you tried sorting by the accumulated expression as well?

[#5]

Hi Pravesh,

Yes I tried that, but it is almost like the sorting is locked after the Rangesum( column is introduced... Not sure what is going wrong.

Do you know of any other way to solve it?