Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
OLAP Pivot Table returns #N/A for custom calc.
When I try to use the Running Total custom calculation within the Value Field
Settings (under the Show Value as tab) on an OLAP Pivot Table, Excel returns #N/A. I know some of the Summary options cannot be changed for OLAP data in Pivot Tables, but the Help in Excel doesnt indicate any limitations on the data source for custom calculations. Plus, the drop down box underneath Show Values as is enabled for OLAP pivot tables whereas the unavailable Summary functions are properly disabled. In fact, many of the other custom functions, such as % of Difference, do not work either. The Running Total calculation in Pivot tables based on non-OLAP data sources works as expected. Any clues or answers will be much appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2007 Pivot Table or OLAP Add-in | Excel Discussion (Misc queries) | |||
how do I identify the OLAP datasource of a pivot table | Excel Discussion (Misc queries) | |||
How to make my own formula for OLAP Pivot table? | Excel Discussion (Misc queries) | |||
Pivot Table - OLAP Cube | Excel Discussion (Misc queries) | |||
zero values in olap pivot table report | Excel Discussion (Misc queries) |