
1. Re: Sorting Dimensions by Calculated Fields That Use Table Calculations
Andrew Watson Aug 17, 2016 10:20 AM (in response to Sam Fleisher)1 of 1 people found this helpfulPut the calculated field you wish to sort by as the first pill (the left hand pill) in the rows shelf and ensure it's discrete (blue). It has to be the first pill in the rows. You can uncheck 'Show Header' to hide it. Note if you find it sorts the wrong way to that you wish then multiply the result by 1 in a new calculated field and sort by that new field.

2. Re: Sorting Dimensions by Calculated Fields That Use Table Calculations
Sam Fleisher Aug 18, 2016 9:48 AM (in response to Andrew Watson)Hi Andrew,
Thanks so much!
I did exactly what you said and it still doesnt give me an option to sort by that calculation. I tried multiplying it by 1 and it still doesnt work. Any other ideas?

3. Re: Sorting Dimensions by Calculated Fields That Use Table Calculations
Andrew Watson Aug 18, 2016 11:15 AM (in response to Sam Fleisher)Can you provide some screenshots of your set up? Include all of the pills placed on the view. Thanks

4. Re: Sorting Dimensions by Calculated Fields That Use Table Calculations
Sam Fleisher Aug 18, 2016 11:18 AM (in response to Andrew Watson)Hi Andrew,
I've been playing and I got it to work but only is ascending order. It wont let me do descending order. Any thoughts?

5. Re: Sorting Dimensions by Calculated Fields That Use Table Calculations
Andrew Watson Aug 18, 2016 11:22 AM (in response to Sam Fleisher)1 of 1 people found this helpfulYes, multiply it by 1. Create a new calculated field to sort, [CurrentField] * 1. This way of sorting only allows ascending...hence why the value needs to be multiplied by 1, reversing the order.

6. Re: Sorting Dimensions by Calculated Fields That Use Table Calculations
Joe Oppelt Aug 18, 2016 11:22 AM (in response to Sam Fleisher)1 of 1 people found this helpfulThat's what the 1 is for. Create a second calc like this:
[Your table calc] * 1

7. Re: Sorting Dimensions by Calculated Fields That Use Table Calculations
Sam Fleisher Aug 18, 2016 11:27 AM (in response to Joe Oppelt)1 of 1 people found this helpfulI had the 1 in and it wasnt reordering, but I realized I still had the original table calc + the one * 1 and when I removed the original, it worked! Thanks all!

8. Re: Sorting Dimensions by Calculated Fields That Use Table Calculations
Andrew Watson Aug 18, 2016 5:00 PM (in response to Sam Fleisher)1 of 1 people found this helpfulGlad you got it sorted Sam, can you please mark one of the answers correct and close out this thread? Thanks

9. Re: Sorting Dimensions by Calculated Fields That Use Table Calculations
Joe Oppelt Aug 19, 2016 7:42 AM (in response to Andrew Watson)Andrew  I took care of marking this thread "Correct".

10. Re: Sorting Dimensions by Calculated Fields That Use Table Calculations
Andrew Watson Aug 19, 2016 7:47 AM (in response to Joe Oppelt)Cheers Joe, far too many open 'closed' threads on here...