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!

[swuehl]

Can you describe a bit closer how your want to sort your table (e.g. by some sample lines of sample data)?

I think you should be able to use the sort properties to define the sort order, i.e. sort first by X, then by Y

[sunny_talwar]

May be RangeSum(Dimension1, Sum(Measure1))

It would be better if you provide real sample instead of just names because we won't really know the data behind the names and it becomes difficult to provide accurate answers.

[#4]

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

[#5]

Sure, please see my reply below.

[#6]

Thanks, that did not work unfortunately, but please see my reply below

[Colin-Albert]

How many dimensions and how many measures have you added to your table?

You can use the Data, Add Column option to add as many dimension and measure columns as you require.

[#8]

Yes that's right, but I need to sort my names, adding more dimensions/measures won't solve the problem

[Colin-Albert]

Expand the Sorting option and add the dimensions and measures you wish to sort by. 

[#10]

I want to sort my Name dimension by 2 different things: 1. City dimension , and then 2. Measure1