user selectd columns in report

Hi,

I have this request: user wants a report where he can choose to add some columns to it.

This is the scenario: I have a calculated table with 5 columns (ie. product, category, state, city, salesperson) and the numeric count of product. (CoP)

Now, the basic report always shows Product and CoP. The user wants to have the option to select what columns to show in a table or matrix, like this:

Product  (Category and/or State and/or City and/or salesperson)  CoP

The only restriction is that Product has to be the first column and CoP the last.

I have been able to dynamically change calculated measures in a report, but this is a new one for me.

Thank you in advance for your kind response.