This blog post Customizable Straight Table explains how to do this as in create "a customizable straight table or ad-hoc report where the user can select the dimensions and measures that should appear in the chart"
Check this as per the Bill suggestion,
Customizable straight table,
By creating Dimensions and Expressions like this,
Data: LOAD Customer, [Sales Order ID], ShipDate as Date, Product, Sales, Quantity FROM [Sales Orders.xls] (biff, embedded labels, table is [Sales Orders$]); Dimensions: LOAD * INLINE [Dimensions Call Customer Call Date Call Sales Order ID Call Product ]; MetricsORMeasures: LOAD * INLINE [MetricsORMeasuresNO'S,MetricsORMeasures 1,Call Sales 2,Call Quantity ];
Using the Selection of dimensions and expression through list box , the straight table will display the Results.
Hope this helps,