Sum up reoccuring data in the order it occurs
Ok Ive set up the data with the pivot table
Which tells me totals of each category but I can't get it to separate the 2 runs of green apples or keep everything in order like below.
Sum Up Table
Green Apples 127
Red Apples 98
Green Apples 139
Green Pears 62
Last edited by rdperry11; 02-08-2015 at 06:34 AM.
|