title: OBIEE 12.2.1.0.0 - Fully control sort order of a chart
body: <p>Is it possible to control the sort order of all the elements of a chart?</p>
  
  <p>The specific case I have is that of a 100% stacked bar chart of a sales table with ProductName, NumSales, CustomerAge and CustomerAgeGroup, where this last attribute is defined with a CASE over CustomerAge so each customer has 'Child', 'Teenager', 'Adult' or 'Pensionist' as CustomerAgeGroup. </p>
  
  <p>In the chart each bar is a product (ProductName) and the bar is coloured showing the distribution of CustomerAgeGroup of the buyers of each product. Right now, the chart reads something like this:</p>
  
  <ul>
  <li><strong>Action Man:</strong> 'Teenager' (10%), 'Pensionist' (25%), 'Child' (5%), 'Adult' (60%)</li>
  <li><strong>Matrix:</strong> 'Teenager' (20%), 'Pensionist' (10%), 'Child' (5%), 'Adult' (65%)</li>
  </ul>
  
  <p>I am not worried about the order of ProductName, but notice the descending order of CustomerAgeGroup: is it possible to display CustomerAgeGroup sorted by the order of CustomerAge and get something as shown below?</p>
  
  <ul>
  <li><strong>Action Man:</strong> 'Child' (5%), 'Teenager' (10%), 'Adult' (60%), 'Pensionist' (25%)</li>
  <li><strong>Matrix:</strong> 'Child' (5%), 'Teenager' (20%), 'Adult' (65%), 'Pensionist' (10%)</li>
  </ul>
  
  <p>Note that I have already tried to include in the data the sorted column CustomerAge and keep it Hidden in the chart, but that did not work.</p>