Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I was using the custom calculation feature in my pivot table. I used the % Of and chose a base item from a base field. It converted the total of the base item that I chose fine, but it converted all the other numbers to #N/A. What might I be doing wrong?
I have included a sample from the pivot table. Thanks in advance for the replies. Grant. $15,107,896 #N/A $1,264,494 #N/A $2,588,996 #N/A $4,778,696 #N/A $23,740,082 100.00% |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
### showing up in pivot table. | Excel Discussion (Misc queries) | |||
Showing all rows in a pivot table | Excel Discussion (Misc queries) | |||
Value not showing in pivot table | Excel Discussion (Misc queries) | |||
Showing Pivot Table total on Associated Pivot Chart | Excel Discussion (Misc queries) | |||
Pivot Table not showing subtotals | Excel Discussion (Misc queries) |