custom sort pivot column

[zohebakber]

Hi Team,
I want to custom sort the Pivot Column.
See the screenshot attached.
In the screenshot, I want to show particular manufacturer as first entry in the column and likewise.

Please share the inputs.
Thanks

[zohebakber]

Can you check this
@harikm007 @Oleg @Ido_QBeeQ 

[Ido_QBeeQ]

Hey @zohebakber 

If you'd like to achieve this without a script, you can add append order INT to each manufacturer value and set them int he order of the manufacturers that you're interested in.

Another option would be to create that order INT as another column, add that to the columns and create a script which will order them by that INT, then you can hide that column.

Feel free to reach out for more info

QBeeQ - Gold Implementation & Development Partner

[email protected]

[anggunn]

Is there a way to hide the sort column when it is specified as a column (and not a row)? I have the same problem where the manufacturers should not appear in alphabetical order across the top but rather in a pre-defined order. 
Here, I have a sort value defined in my cube. I do not want those numbers to be displayed to the users. Is there a way to hide the 1, 2, 3,11, 12, 21,22 values?

[zohebakber]

It's done Ido..
Thanks