Let users re-arrange matrix fields?

[holypond2001]

Hello,

After publishing a report, is there a way to let users rearrange the matrix fields however they want (column orders, row hierarchy, etc)?

I'm thinking something similar to how pivot table works in Excel, where users can drag and move around the fields to change up the table view.

The only way I could've achieved the desired result is to deselect and re-select the dimensions and measures from the drop down list in an order I want, but this is a bit tedious.

Thanks!

[ThxAlot]

Field Parameter does the trick.

[holypond2001]

I'm already using field parameters for dimensions and measures as shown in my screenshot. But this requires users to unselect the default selections and re-select them to re arrange the column orders.

Is this the only available option?