Retaining Format in Excel Pivot Table - 10-03-2006 , 12:49 AM
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
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
Re: Retaining Format in Excel Pivot Table - 10-12-2006 , 08:45 PM
Excel isn't a real reporting tool
Spit on anyone that uses it for anything.
prabodhjp (AT) gmail (DOT) com wrote: