This project has moved and is read-only. For the latest updates, please go here.

Multiple DataFields on PivotTable

Dec 16, 2011 at 5: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. 



Apr 12, 2012 at 3:44 PM

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

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