In a Pivot Chart, need to sort at multiple levels within that level

[suepenick]

I need to sort sales by SOType, Series, CostType  High to Low on Dollars within the Material cost type group

we want to see sales High to low within each group.

I cannot get the expression to work in the sort tab.

This is what I have in the expression on the CostType field:

Sum(total<SOType,Series,CostType>(SalesAmount))

Any help?

[marcus_sommer]

Take a look on this: Perfectly Sorting Pivot Table (by A-Z. y-Value set for each dim-level)

- Marcus