Sort by expression using one measure and one dimension

[#1]

I am sorting the rows in my table by expression. Right now I'm using one of my dimensions (Say we call is Dimention1) as the expression to sort, but I need to sort rows by another measure (say we call it Measure1), too. Is this possible?

Right now the expression is basically: Dimension1

If I change it to sum(Measure1), then I lose the sorting by Dimension1. How can I have both?

Thanks!

[#2]

Is it now clear what I'm trying to do? Thanks.

Sample to expand more on what I'd want to do:

ID	Name	City	Measure1
12	Alex	Winnipeg	156
35	Justin	Halifax	800
57	Tina	Toronto	299
87	Patricia	Halifax	200
35	Jason	Winnipeg	580

I have Measure1 as a measure in my pivot table, name in Rows, and City in columns. I want to sort the rows in a way that it first sorts by City, and then for each City, sorts by Measure1. Result in the following:

	City
Name	Halifax	Toronto	Winnipeg
Patricia	200	-	-
Justin	800	-	-
Tina	-	299	-
Alex	-	-	156
Jason	-	-	580