Sorting Crosstab according to total of measure value
Posted on March 10, 2014 at 1:26am
Hi,
I gone through lot of threads in this community regarding this but couldn't get a proper solution. Sorry for reposting it.
Is there any way to sort the crosstab according to the total of measure value ASC/DESC.
I-report version is 4.7.0
Please help.
Regards
Hisham.A
Joined: Sep 4 2013 - 5:07am
Last seen: 6 years 11 months ago
Posted on March 13, 2014 at 1:17am
Hi
Please somebody help on the above topic.
Regards
Hisham.A
Joined: Sep 4 2013 - 5:07am
Last seen: 6 years 11 months ago
Posted on March 19, 2015 at 9:17pm
hi hisham,
you just select your row group and change property 'order' to asc or desc and 'order by exp' to your measure.
Regards
Yusuf.F
Joined: Mar 19 2015 - 9:08pm
Last seen: 2 years 6 months ago
Posted on March 7, 2017 at 11:08pm
+1 to Yusuf for the correct answer!!
Joined: Apr 9 2012 - 1:39am
Last seen: 2 years 9 months ago
Posted on February 8, 2018 at 12:45pm
FYI, in the Expression Editor GUI the row group measure doesn't always appear, so you might have to manually add it. Once you've pasted the variable name into the editor, the GUI still won't recognize it, the the report will run and perform the proper sorting.
Joined: Jun 20 2017 - 8:32am
Last seen: 1 year 5 months ago