Forum Discussion
Sort in a slicer
Ok, thanks everyone for your help.
I undestand better my issue.
I want to use just a attribute (a single column) from a table "Products" for a slicer, but I didn't create first a table for this attribute.
I think I should first create the table for the attribute with id and label as columns, and after it will be possible to use differents columns of the new table for the slicer.
B.
Hi Chris,
Thanks for help.
When I select my slicer, the "Sort by Column" button is disabled (grey).
And in the "Field"/"Champ" for the slicer, I can only put one object, (the id or the label), not both.
Solution SageYou need to go into the table/data view, click in the column to be sorted, click "sort by column" and then select the surrogate sort column".
So, select your original field in the fields section, and from the modelling tab, choose Sort by column and pick another field (label) to use that field when sorting the original field.