I have created Dimensions explicitly in multiple tables as below:
Table1:
...
...
'Dimension1' as Dimension
Table2:
...
....
'Dimension2' as Dimension
Table3......
so on.
When I add 'Dimension' in any chart as my dimension, I get Dimension1, Dimension2, Dimension3...as my Dimension values. How do I sort them in order? I have tried the sort in the chart properties but it doesn't give me the order.
I guess I am not even sure that how these tables are linked to each other except the Dimension field and what is the goal. Are you sorting by Text (A-Z or Z-A)?
Can I assign something in each table, like a serial number that I can use in the char as another Dimension so that I can sort based on that serial number
