custom sort pivot column
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
Forum Discussion
4 Replies
Replies have been turned off for this discussion
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
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?
It's done Ido..
Thanks
