Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

CalcioscacchiApr 8 2019 — edited Apr 8 2019

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

MonthMeasure1
Measure 2
Measure 3

Gen

5.38%2.09%1.28%
Feb5.42%2.23%1.51%
Mar5.71%2.26%1.60%
Apr5.71%1.99%1.4%
TOTAL5.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.

Comments