|
Home > Archive > MS SQL Data Warehousing > October 2006 > Retaining Format in Excel Pivot Table
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Retaining Format in Excel Pivot Table
|
|
| prabodhjp@gmail.com 2006-10-25, 6:00 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
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
| |
| susiedba@hotmail.com 2006-10-25, 6:00 am |
| Excel isn't a real reporting tool
Spit on anyone that uses it for anything.
-Susie
prabodhjp@gmail.com wrote:
> 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
|
|
|
|
|