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 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.