How to deal with sorting added columns?

[YanGerzon]

Hi,

I have some columns in a story that are based on a dimension of the model i created.
I then added a few columns of my own that SUM some of the existing ones.
1)Is there a way to sort these additional colums cause when i try to make a custome sort i dont see them in the list, only the columns based on the dimenstions of the model.
2)Is there a way to hide the columns i am summing?
When i hide or exclude them they also dissapear from the SUM formula.

Thanks.

[Jay_Gandhi]

Hi Yan,

Have you considered converting all of your columns to calculated measures (including the SUM column).

If this is possible in your use case you will have more flexibility in sorting and choosing to not display some of these columns.

Jay

[pooja_elangovan]

Hello Yan Gerzon,

Actually, we can't hide the SUM columns. At the same time I can't understand your question clearly can you please attach a screenshot.

Thanks,

Pooja.