Order by value the measures in a pivot table or in a graph view

Calcioscacchi

Hi!

I'm an user of OBIEE 11g

I have some measures divided by months, and a total of the year (rolling) of the same measure. Take the following table as an example

Month	Measure1	Measure 2	Measure 3
Gen	5.38%	2.09%	1.28%
Feb	5.42%	2.23%	1.51%
Mar	5.71%	2.26%	1.60%
Apr	5.71%	1.99%	1.4%
TOTAL	5.52%	2.19%	1.46%

I want to order in a automatic way the measures by the total value. Suppose for example that with the month of may the data for the total row will be 5.19, 6.2, 1.45.

I want the the new order would be Measure 2, Measure 1, Measure 3.

Is that possible?

Thanks.

Gianni Ceresa

Hi,

If this is a table view, the order or columns isn't dynamic, it's fixed based on the order the columns are places into the table view. Only the rows could be sorted in a different way.

More in general you seem to be wanting to sort based on the value of a total row, if that's the total OBIEE does calculate automatically when you decide to display a total, you can't do much with it, you can't reference it for a sorting or anything else. If this is your case, even without the limits of a table view you wouldn't be able to set a sort based on the total as it doesn't really exist anywhere in your analysis. It's just a visual element.