Forum Discussion

syasmin25's avatar
syasmin25
Icon for Helper V rankHelper V
4 years ago

sort Paginated report Month

Hello, 

I am trying to sort the months (which appear in the column) of a matrix table in a paginated report. However, It does not seem to be working. 
As you can see in the image below, my months are not in order.


I have also tried interactive sorting as you can see. 



Any ideas or suggestions would be highly appreciated.



General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    You need to add another column with the Month Number that corresponds to that Month's Name. Then in the Column Groups>Properties>Sorting>> Add the Month Number field to sort A-Z:

     

    • ADD_'s avatar
      ADD_
      New Member
      1 year ago

      This is very helpful and working fine.

  • AbhiSSRS's avatar
    AbhiSSRS
    Icon for Solution Sage rankSolution Sage
    4 years ago

    Can you please give more details .. like the dataset used which is populating month here. The sorting may need to happen at the dataset level . if possible please attach the rdl.