Microsoft KB Archive/259587

= XL2000: Calculated Member Is Not Displayed in PivotTable =

Article ID: 259587

Article Last Modified on 9/25/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q259587



SYMPTOMS
When you create a PivotTable from an Online Analytical Processing (OLAP) cube, all of the calculated data that you selected to be included in the report does not appear.



CAUSE
This problem occurs when you select calculated members in your OLAP data cube whose parent is not a measure dimension.



STATUS
Microsoft has confirmed that this is a problem in Excel 2000.



MORE INFORMATION
OLAP databases are organized to facilitate the retrieval and analysis of large amounts of data. Before Excel displays summarized data in a PivotTable report, an OLAP server performs calculations to summarize the data. The OLAP server returns only the summarized data to Excel, and only returns data if the data member is from a measure.

When you are working with a PivotTable report based on OLAP source data, you can only use dimensions as row, column, or page fields. You can only use measures as data fields.

For additional information about dimensions, measures, and using OLAP data sources in your PivotTable, click the article number below to view the article in the Microsoft Knowledge Base:

234700 XL2000: Differences Between OLAP and Non-OLAP PivotTables

Additional query words: XL2000

Keywords: kbbug kbpending KB259587

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.