Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
Maybe looking at Debra Dalgleish's new instruction page would help:
http://www.contextures.com/xlPivot10.html David wrote: = 'SumOfNumber of bl''s'/ GETPIVOTDATA(" eBL%",$A$14) I'm trying to create a calculated vield in my pivot table to find market share or the sum of one record of data on the total of that data object. However when I try to add the above mentioned calculation I receive the following error message: " Referencs, names, and arrays are not supported in pivot table formulas. " Do you know any way to handle this error and accomplish what I want to do? rgds David -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
pivot table | Excel Worksheet Functions | |||
Removing errors from a Pivot table | Excel Discussion (Misc queries) | |||
Pivot Table services | Excel Discussion (Misc queries) | |||
Problem with Pivot Table Drop-Down Menus | Excel Worksheet Functions |