I have a dataset where organizations make up the rows and in the columns I have the county that each organization is in and 10 columns of annual revenue ex 2010 revenue in 'C' 2011 in 'D' 2012 in 'E'
I have the rows in my pivot table set as county, and I want to see the average, total, and single maximum revenues in columns within the pivot table. So I want column B to contain the average annual revenue of all organizations within the county in A across all years. I have tried to make a calculated field but I can't get the formula to do what I want.
Any help would be greatly appreciated
Bookmarks