I have a spreadsheet of invoices exported from my accounting program. I created a column and copied the invoice date to it then formatted the column with Custom, mmmm-yy. I want to create a pivot table that says for Apr-14 the total for object Code 6630 $$$$. I want to see that in April, 2014 we spent X for Food from Shamrock, Muder, and Sysco. Then what we spent in May, etc. I might not even care about the Vendor but I do want it summarized by month no matter how I do it, and I am trying to isolate our food costs.
It is not combining all of the Apr-14 lines though, but listing them separately.
Thanks
Carla
It is not combining all of the Apr-14 lines though, but listing them separately.
Thanks
Carla