Good morning,

I did a relatively simple pivot table earlier this week and I added a calculated field to that pivot table. That calculated field helped me out immensely.

However, I'm now doing a new pivot table in which I'm pulling data from two tables (by checking the "add to data model" box). This works great. However, when I now try to add a calculated field to this pivot table, the "calculated field" option is grayed out.

It seems to me (non-excel guru) that Excel won't let you do a calculated field if you pull from more than data set. Is that true and/or is there a simple work around?

Thanks!
Joe