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?
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
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.
Sample to expand more on what I'd want to do:
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:
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.