Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 213 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Order by value the measures in a pivot table or in a graph view
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 |
| ||
|---|---|---|---|---|
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.
Answers
-
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.
0
