1 Reply Latest reply on Apr 8, 2019 3:32 PM by Gianni Ceresa

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

    Calcioscacchi
    Calcioscacchi Apr 8, 2019 3:03 PM

      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.

      • 66 Views
      • Tags:
        • 1. Re: Order by value the measures in a pivot table or in a graph view
          Gianni Ceresa
          Gianni Ceresa Apr 8, 2019 3:32 PM (in response to Calcioscacchi)

          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.