I have set formatting of a calculated member in a cube to 'percent'.
When I view the calculated member in an office 2003 pivot table, it
does not apply the formatting defined in the cube. Is there a way I can
get measures to display the format defined in the cube in a pivot
table?
Every time I have to change the format in Excel for these Fields, also
once these fields are removed from the data fields and placed back it
loses its format.

The same question was posted way back in 2004 but there was no answer
to this question and even i am facing the same problem

Excel isn't a real reporting tool

Spit on anyone that uses it for anything.

-Susie


prabodhjp (AT) gmail (DOT) com wrote: