You can use emxGridTable.jsp to design table views that show dynamic columns that intersect with row data, similar to pivot tables in spreadsheets.
Dynamic Grid Tables Dynamic Grid Examples URL Parameters Accepted by emxGridTable.jsp