I'm trying to get visual totals to show up at the end of a list of members, but still be able to ORDER them in ascending or descending order (preserving hiearchy, ASC and DESC).

Something like:
SELECT ORDER (Hierarchize(VisualTotals({[Foo].Members}), POST), [Measure].[Bar], DESC)

However, ORDER moves my [Foo].All member to the top (regardless of ASC or DESC).

Is there an easy way to do this without resorting to pulling out the parent items and managing the order myself? It seems like a common usecase to have visual totals at the end (bottom), but still be able to sort.


Thanks