Hide a Dimension

[#1]

Hi All

Is it possible to hide a dimension? I have a key figure called "Sort" with numbers from 1,2,3....X That I sort by, but I do not need to show these figures.

Best regards

Bjarne

[bharatkishore]

HI BjarneQV,

Can you please tell me which chart are u using? Bec in pivot table u can't hide dimensions u can hide only in straight table.

[sivarajs · Accepted solution]

Goto--> Presentation--> select column --> Hide Column or Conditional =0

[jagan]

Hi,

Instead of adding an extra dimension you can control the sort order by

-Chart Properties -> Sort -> Select Expression checkbox -> =Only(YourSortDimension)

Hope this helps you.

Regards,

Jagan.

[#5]

Thanks Jagan, that's all I really needed! thank you.