Sorting by Summary in Group Footer
Posted: Mon Jan 30, 2017 7:24 pm
Hello,
I have a report I have grouped by one data column. In the Group Footer I am adding a text box sum(Have also tried using Calculated Columns). I would like to sort by this added summary, descending - to have the highest sum/grouping first and then so on. I do know how to apply sorting from within the data band > sorting, as well as in the interaction menu. However this appears to only sort the line items WITHIN the group.
To summarize, If I am grouping my report by one data field, how can I sort the separate groupings themselves BY the added summary text box?
For reference's sake I am using Reports.Web 2011.3.1200.
Thanks,
David
I have a report I have grouped by one data column. In the Group Footer I am adding a text box sum(Have also tried using Calculated Columns). I would like to sort by this added summary, descending - to have the highest sum/grouping first and then so on. I do know how to apply sorting from within the data band > sorting, as well as in the interaction menu. However this appears to only sort the line items WITHIN the group.
To summarize, If I am grouping my report by one data field, how can I sort the separate groupings themselves BY the added summary text box?
For reference's sake I am using Reports.Web 2011.3.1200.
Thanks,
David