This project has moved. For the latest updates, please go here.

Multiple DataFields on PivotTable

Dec 16, 2011 at 4:53 AM

Do I need to do anything special to add more than one of the same datafield with different functions like count, sum, and average to a pivottable?  Whenever I try this, the code runs fine but Excel crashes when I open the file. 

Thanks!

David

Apr 12, 2012 at 2:44 PM

Anyone solved this problem? Is that possible to add multiple datafields? If so, how?

Sep 23, 2013 at 11:53 AM
Possibly pivot fields have to have a unique field names. Try to rename your columns, this workes for me in a similar situation,