Expression in Pivot Chart - sorting issue

[#1]

Hi,

I have  created a pivot chart using 3 dimensions with several different rates calculated as expressions.

The issue I am having is that I need to sort the pivot by one of the expressions e.g. (AR)

I cannot sort the pivot in the usual manner (using the sort tab) as this only affects the dimensions and not the expressions.

Is there a possibility to add a sort to my expressions?

They are simple expressions (e.g.)  sum(Activity) / sum (time)

Regards,

Gregg

[#2]

I have a somewhat similar issue.. I have a pivot table detailing sales data (company, rep, close date, product, etc.) The last dimension is the Year-Month in which the sale closed, and I pulled that up as a horizontal dimension.

It used to work fine, but now the YearMonth sort is all over the place (instead of ascending, which is what we want).

How do I ensure the horizontal dimension is sorted properly? It is a text field "2012-Jun", "2013-Feb", etc. but I created a unique number field for each month (from (Year(CloseDate)-2010)*12+Month(CloseDate) called OMN. When I tried to sort the last dimension using expression = OMN, it didn't make a difference - the months were all over the place.

Any thoughts?