OLAP Pivot Table returns #N/A for custom calc.

V

VPDan

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 doesn’t 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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top