list comaprision
I have 3 years worth of sales info. It looks like:
ITEM/DESCRIP/MERCH AMT/....../LAST PURCHASE DATE I want to have a quick way of showing a comparision of what the customer no longer buys, new items they buy and a increase or decrease chart for overall total. I want my finished product to look like: 1996 1997 ITEM/DESCRIP/............DATE ITEM/DESCRIP/.......DATE 1 XXXXX 8/01/96 BLANK IF THAT ITEM WAS NOT PURCHASED 2 XXXXXXXXX 8/03/96 2 XXXXXX 6/5/97 with my columns side by side and so on. Any sugestions? I have tried a pivot table, but continuosly get an error. |
All times are GMT +1. The time now is 08:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com