I have a spreadsheet with two columns showing percentages by commodity already. When I transfer to Pivot table/Chart the columns are coming in as "sum of" I don't want these to sum just to transfer over as the values they are already. I tried changing the field but that didn't work.
Pivot.PNG
Bookmarks