Forum Discussion
matrix column ordering with slicer
I have the following table (group,entity_name,entity_order,value) I need to present as a matrix with entity_name as the column and value as the value - the matrix is always sliced by the group attri...
SamWiseOwl
Super User
Super UserHi johnmerm2
Would it be possible to duplicate the table in the Query Editor, delete the extra columns, remove duplicates.
Then in the front end join using the entity_name, on the unique table sort entity_name by entity_order.
I'd need to do this when I change the group selection in the slicer
