Hello,
I would like to know if someone know how to sort a few column in a specific way?
A drawing will be easier to understand:
Col 1 | Col 2 | Col 3 | Col 4 | Col 5(number)
-Cat1…250
…-Subcat1…150
…value…value…100
…value…value…50
…-Subcat2…100
…value…value…80
…value…value…20
-Cat2…150
…-Subcat1…100
…value…value…60
…value…value…30
…value…value…10
…-Subcat2…50
…value…value…30
…value…value…20
…
…
.
1st Level (Cat) should be descending, 2nd Level(subcat) should be descending and 3rd level too.
All level should be sort by number value.
I hope you will understand what I mean.
Thanks in advance for your help.
Regards,
Jeremy
Subject: You can’t sort categories by total…
…since the total isn’t known until after the rest of the index is created (after sorting is done). In order to sort that way, you would need to record the category total on all of the documents in the category (not going to happen if documents can be in more than one category, and prone to conflicts under all circumstances) and sort on a hidden column containing that value.
Subject: try this
Make columns 1 and 2 normal categorized containing the single field. Then create a hidden column, and put into it the values for columns 3, 4 and 5 as a single string. Make sure that you pad the strings for each value to be the same length.
So, example: field 3 = 10, field 4 = 1045, field 5 = 123. You want the concatenated string to be 001010450123. Then sort this hidden column.
Subject: Thanks but…
Thank you for your help, but it’s not what I mean.The last column is the only column containing numbers.
And she is “Totals” type. (In the second tab of the column property).
I would like to sort the total descending (cat line). sutotal descending (subcat line), and number descending. (document line)
Regards,
Jeremy