Forum Discussion
sorting by two rows in a matrix
Hi Anonymous ,
I want to sort both by the number of searches in descending order, and then when you click the '+' to expand a row, those dates that the searches took place would be in descending order, regardless of how many searches there were.
So, sort by number of searches descending when the rows are collapsed;
sort by date descending when the rows are expanded BUT keep the sort descending by number of searches on the upper heirarchy.
I'd also like to add that clicking on the ellipses and then sorting by the date removes the sorting by descending number of searches.
It puts the names in alphabetical order, which isn't the goal.
I hope that makes sense!
If it's not possible, I'll just try to give these results in a different way.
Hi Anonymous ,
This may require you to make sort settings for two times:
1. When there is only one hierarchy level Name in matrix, select the More options (...) menu in the upper right corner of the matrix, then select Sort descending and select Sort by, and then select the field Number of Searches
2. When you click the "+" in front of Name to expand the data, select the More options (...) menu in the upper right corner of the matrix, then select Sort descending and select Sort by, and then select the field Date
Best Regards
Anonymous
Apologies for the late response--it's been a busy week!
Unfortunately, I've tried this, and it normally overwrites the previous sort by Number of Searches.
I will try again though and let you know!