pivot table calculated fields

J

joemeshuggah

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?
 

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

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
Slicers and Calculated Items in Pivot Table 2
Additional columns for Pivot table 0
Pivot Table Counting Text Data 0
Problem inserting calculated pivot fields into Pivot Table (2007) 1
Custom Calculation in a Pivot Table 1
Finding the right style field in VBA 0
Formula in Pivot Table 0

Top