Hi,
I am currently trying to analyze a large sales database (90K+ entries) to focus on repeat business where each line represents a single sale, which might be done by a repeat client or a new client. I am currently doing simple analysis using pivot tables.
I was able to add lines to my database to add the information on whether or not a client is repeated, however the information has been added to a sales line, therefore when I use a pivot table, I obtain results of total number of sales by repeat customers rather than the total number of repeat customers. I thought of creating a new table with only client information (removing multiple lines per client) which I used a pivot table to extract the informtion from the original set, but I am unsure of how to develop it to include all other useful data (province of client, industry, product, etc).
If you have any help or advice it would be greatly appreciated.
Have a good Sunday!
Bookmarks