Sorting Crosstab according to total of measure value

0

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

hishamkmr's picture
Joined: Sep 4 2013 - 5:07am
Last seen: 5 years 3 months ago

4 Answers:

0

Hi

 

Please somebody help on the above topic.

 

Regards

Hisham.A

hishamkmr's picture
Joined: Sep 4 2013 - 5:07am
Last seen: 5 years 3 months ago
3

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

 

 

firdausofyusuf's picture
Joined: Mar 19 2015 - 9:08pm
Last seen: 10 months 1 week ago
0

+1 to Yusuf for the correct answer!!

JasperTechie's picture
Joined: Apr 9 2012 - 1:39am
Last seen: 1 year 1 month ago
0

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.

dstevens_2's picture
Joined: Jun 20 2017 - 8:32am
Last seen: 1 month 2 weeks ago
Feedback