Pivot table options
Pivot table options
I have a very simple DB - in columns - Date, Agent ID, Client, Number of items sold. When creating a Pivot View I am putting the date in the Column, Agent ID in Rows and then number of items sold in data. I do not have an option to select sum in place of count. How can this be fixed?