Hello. I created a pivot table and I also included ADD to data model. Now it won't let me add a calculated field? Why?
Hello. I created a pivot table and I also included ADD to data model. Now it won't let me add a calculated field? Why?
unless you have power pivot you can't create calculated fields/measures with a data model pivot
Josie
if at first you don't succeed try doing it the way your wife told you to
I do have powerpivot, but I guess I have to add the calculated field in the manage data section? I already created a pivottable and added it to the data model, which is using powerpivot behind the scenes.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks