% format display problem in pivot table

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: urgent <urgent@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Fri, 22 Apr 2005 14:12:21 -0700

When pivot table (xp) connects to OLAP Cube, the percentage(numberic data
like 4,111,111) format wouldn't work any more. I can re-format them in excel,
but is there any way excel can automatically realize the format in cube???

Also, how to format %... in cube?

thanks in advance.
.

Follow-Ups:
- Re: % format display problem in pivot table
  - From: Deepak Puri

Prev by Date: Re: Drillthrough not always working with OWC
Next by Date: Re: problem to display calculated dimension members in pivot table
Previous by thread: DSO function failed
Next by thread: Re: % format display problem in pivot table
Index(es):
- Date
- Thread

Relevant Pages

Re: Retaining Format in Pivot Table
... Excel 2003 doesn't support the server-defined format. ... When I view the calculated member in an office 2003 pivot table, ... does not apply the formatting defined in the cube. ...
(microsoft.public.sqlserver.olap)
Re: Retaining Format in Excel Pivot Table
... When I view the calculated member in an office 2003 pivot table, ... does not apply the formatting defined in the cube. ... Every time I have to change the format in Excel for these Fields, ...
(microsoft.public.sqlserver.datawarehouse)
RE: Retaining formatting in Excel defined in cube
... be applied in an Excel pivot table when you are viewing measures. ... I want the format for the measures that I have defined in the cube to be ... is there a non-programmatic way to allow the format that is ...
(microsoft.public.sqlserver.datawarehouse)
Re: Bug new ExcelAdd-In for Cube Analysis ?
... > Display Format from Unit Sales in the Cube = Standard ... > Display Format from Store Sales in the Cube = Currency ...
(microsoft.public.sqlserver.olap)
Retaining Format in Pivot Table
... 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, ... Every time I have to change the format in Excel for these Fields, ...
(microsoft.public.sqlserver.olap)