I'm having similar problem discussed here - I wish someone can take a look at file below - I want to sort the table by the measure in column I ? I've been trying to do it in the 'more sort options' in the area_title column but nothing seems to work. have 'sort automatically' unchecked as suggested above but still not working.
http://sdrv.ms/IGGy6C
http://sdrv.ms/IGGy6C