5 Answers, 1 is accepted
in your crosstab month column group how are the items ordered. Januar, Februar, March, .... or in another form, lets say from A-Z by month names. If you start from a DateTime field the order should be correct by month order. Do you have an "ORDER BY" in your sql query? In case you have a special month column in your table to sort by it could be STRING. Then the A-Z order takes places.
Could you send example data or screenshot.
The columns are sorted correctly; however, I want to sort the data within the columns. I attached a screenshot of my crosstab. You can see where I have it sortable by branch and total, but I also want it to be sortable by month.
The initial order of columns is determined by the Sortings of the dynamic column group - select the Crosstab item and open the Group Explorer to see the settings.
If you need to use a Sorting Action to change the order of columns, you can make the Corner cell a controlling item and target the column group by name. This video illustrates the suggestion with our Product Sales demo - https://www.screencast.com/t/uWLLu9mXa.
I hope this helps.
Again, this is explaining how to sort the columns and not the data within the columns. The columns are in the correct order. I want to make the data in the columns sortable.
The Sorting action can be used for sorting rows as well. The target should be a row group of the Crosstab item, where the sorting criteria can be a field or other expression that does not aggregate data e.g. a numeric field or text field (types which can be sorted).
Please note that the Sorting action replaces previous workarounds for dynamic sorting, and we recommend only the settings from Sorting Table Details.