6 Replies Latest reply: Aug 27, 2010 5:04 AM by Aissam Chiki RSS

    Limit results in a pivot table based on expression, sort by different dimension

      I have looked at all the LIMIT discussions and can't find what I am looking for, or at least can't get any of them to work...

       

      See below for pivot table example. There are thousands of records in this table, and I only want to see the top (worst) 50 or 100 based on the MPG. So, of all the records, I want the table limited to the worst 50 or 100 MPG values. But, I need the table sorted by the VEHICLEMGR/FLEET field

      error loading image

      Here is the original report I am trying to mimic.

      error loading image

      Let me know if I need to clarify anything.. Thank you.