How to sort dimension in SAC Story filter

[former_member692525]

Hello,

i am working on a story with dimension filter and i want to sort it . My dimension holds the numeric values 1,2,3,... 12 for 12 months) , when i use this dimension in table or chart , custom sort is possible. however when same dimension i use as filter the values are not sorted. if you have faced similar issue or know how to handle this issue ,please advice. Thank you in advance!

[former_member95956]

Dear Anita,

If you really care about the month sorting, you have to set dim2 as generic dimension includes quarter, for example: set Month ID as Q1_01, Q1_02, Q1_03..Q4_12, and description as Jan, Feb... Dec, I made a simple example with a single axis, refer to themonth-model.pngstory.png picture. And you could follow the rule to build X-Y axis chart, thanks.

Best Regards

Stephen.