Format Measures by Rows or Columns

[LurkAzusa]

In Analysis 8.0, how do I format measures for the whole report instead of row by row or column? An example would be Measure: Sales Dollars to be formatted as Currency with 2 decimals, Measure: Sales Qty to be formatted as Long Integer, Measure: Gross Margin to be formatted as Percent.

It appears that you have to format each row at a time or column at a time. This is unacceptable when there are thousands of rows. I am looking for comparable behavior to Excel Pivot Table, where the format is set at the field setting level.

Any Suggestions?

 

[OliverS]

Have you tried formatting the values on the server? CAPro should pass these through and I think it would be easier to do that by the sound of things.

Oliver