Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Below you find a screenshot where Dim4 values needs to be sorted such that the range 56t-140t comes after the range 50-55t
but it doesn't.
I tried to associate a number with the combination of Dim3 & Dim4 to achieve this(screenshot below)
Dim4 in the table in screenshot 1 is sorted on the basis of sum(num) but still it doesn't get sorted in correct way for the first value of Dim3
Sorting for other values of Dim3 is ok.
Please help.
Regards
Can you please share sample app?
Please find attached
hi, you will notice this is a automatic sorting issue with Excel. Since this is a text field, it is sorting in such a way. You should probably rename the field either numerically or alphabetically to get the desired result
i've associated the field with a number & did sort by sum(num) but doesn't work.
Use max({1} num)
check attached
Hi,
it works
but how does it work ?
please explain
The simple reason. We are taking a Max of "num" and sorting it in asc order. so, as the series you have numbered gets sorted in the asc order and using a set we are ignoring any selection to affect the sorting.
hope this helps.
why doesn't sum(num) work ?
and why does it behave the way it does ? i hope max equals sum here for each pair of Dim3 & Dim4
also when we select/click any value of Dim3 the sorting becomes ok, why is it so ?