Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table calculated fields
is there a limit on how many fields you can have in a pivot table in order to
insert a calculated field? i have 10 columns...if i create the pivot with all 10 columns, and then try to insert a calculated field between columns a & b to show b/a, nothing happens. however, if i create the pivot table by adding columns a and b, then inserting a calculated field to perform b/a, the results appear, but when i repeate these steps to create the rest of the pivot table, the calculated field no longer appears after 3 have been inserted. is there any way around this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Calculated Fields | Excel Discussion (Misc queries) | |||
PIVOT TABLE - SUBTOTAL FOR CALCULATED FIELDS | Excel Discussion (Misc queries) | |||
Pivot table and calculated fields | Excel Discussion (Misc queries) | |||
Pivot Table with Calculated Fields | Excel Discussion (Misc queries) | |||
Sum of Calculated fields in Pivot Table | Excel Discussion (Misc queries) |