Sorting by Measures from Analysis Services cube source
 

I have a fairly simple pivot table and chart showing Members and their
Sales figures.

I can sort by the Dimension members, but when selcting to sort by
Measures I assume it won't let me break the hierarchy, but I cannot
find that as an option..?

Sorting by Measures from Analysis Services cube source
 

I'm sure you can do it; maybe you just need a push in the right direction to
get things started:
http://www.bettersolutions.com/excel...I710431911.htm

http://www.techonthenet.com/excel/pivottbls/sort.php


Regards,
Ryan---

--
RyGuy


" wrote:

I have a fairly simple pivot table and chart showing Members and their
Sales figures.

I can sort by the Dimension members, but when selcting to sort by
Measures I assume it won't let me break the hierarchy, but I cannot
find that as an option..?