Hi All,
I am trying to sort data on a crystal Excel report. The report is generated by item code and gives me the date of purchase in one column and cost of item in a different column. The dates of purchase are mixed between July and August in the same column. Many items were purchased multiple times within the two months and the report shows each one.
I need to compare the costs for each item in July vs. the costs in August. I would like one column with all the costs for July and another column next to it with all the costs for August for easy comparison. I am not so good with pivot tables but if that is the only/easiest way please let me know how it can be done.
See attached workbook.
Thanks!
Attachment 538994
Bookmarks