In the tabular view in Ad Hoc designer, a user can select any field or measure to sort the data by in the table, regardless of whether the field or measure is included in the table.
Need the same capability in the crosstab view. The user should be able to select any field or measure (or combination of) in the data to sort by when creating a cross-tab. Currently a user can only sort the crosstab by what defines the crosstab.
Components | AdHoc |