Forum Discussion
Limitations in calculated field in pivot table ?
Im making a report based on a survey, to make it more interactive i use calculated field. But it seems that i can only make 10 separate calculated fields in one pivot table ?
I was not aware of any limitation to the number of Calculated Fields, that's a bummer. Is it possible to load your data into the data model then use Power Pivot? I have never noticed a limitation in Power Pivot data model to the count of Calculated Columns and Measures.
You might need to learn a little bit more about DAX however, I think you'll find it to be an exciting tool to use.