Sorting in Crosstab report

Sadi shared this idea 1 year ago
Idea Logged

We can sort as expected only if I keep single row field but some of our reports require multiple row fields in a crosstab and also sort by hires (descending order) as it is shown in the attached screenshots.


We would like to sort the similar reports (with or without sections) in descending order based on total number of hires. Please see the screenshots attached.


Does YF have such option to sort?

Comments (5)

photo
0

Hi Sadi,


Can you please tell me how did you get that totals?


I have done couple of different tests on the Crosstab reports:


If I do "Row Totals" on Demographic then I am able to sort on totals as shown below:


0663d8ea8a904638548e9a78184f2426 b42b78f5c4903239d02d106d99aae384


I can also sort on 2 Rows as below:


f0ee033f96430f0db087ce09c88bca67


In this below example, I am able to sort on more than one Row without Totals:


74ff39586965efddebf3835523bc2b56

b579545dffc4cdd7c7028c2511ee3909

0512ada00d5e6cb2a0ae90eadbee46d0


I hope this helps. Please feel free to let me know if I did it wrong or if this is not what you meant.


Let me know if you have any more questions.


Regards,


Mahe

photo
0

Hi Mahe,

Thanks for your reply.

Your second example from the top is somewhat similar to our requirement however we would like to sort the “Total” in descending order. Can you do that?

Keep both Athlete Region and Demographic as being displayed in your example and sort by "Total".

Or, move Demographic to the left then Athlete Region. Athlete Region doesn't have to be displayed as grouped, it can be shown in every row. You can see the screenshots I already attached earlier. The issue is, we can't sort by the Total in such crosstab reports.

Let me know if this is still not clear, perhaps a quick screen share might help.

Thanks,

Sadi

photo
0

Hi Sadi,


You can sort the totals only when you have one field in the row.


10deb2f755ced288a97fc359b233e3c8


"Athlete Region doesn't have to be displayed as grouped, it can be shown in every row." We cannot do this and we have raised an enhancement request Idea - 745


What I have done is moved the Region to the Column and now I get the Total sorted in descending order:


a7c40d6a80fead924403ca7ed8399903


Having 2 fields in the rows will not give us the Sorting option on the total.


If you want this functionality, I will discuss with the team.

Please let me know what you think about it.


Regards,


Mahe

photo
0

Thank for confirming.


As I mentioned in my original note, some of our reports require to have multiple (at least two) fields in the rows and ability to sort on the total would be very helpful in those use cases.


Regards,

Sadi

photo
0

Hi Sadi,


I have created an enhancement request.

This is the ID: 5596


Please let me know if you have any questions.

At the moment I don't have any ETA, but I will keep you updated.


Regards,


Mahe