Excel Pivot Table or Database question

February 9, 2011 at 11:40:04
Specs: Windows XP
I have a database that consists of orders for salespeople. When there are two or more people sharing credit for the order, I want to show those in columns instead of multiple entries for the order. (Essentially, I want one line per order.) Is there any way to do this without searching for the duplicates and parsing them into additional columns within the database?

See More: Excel Pivot Table or Database question

Report •

February 9, 2011 at 11:53:13
I know of businesses where each sales person has their own ID number.

Bob - SP6
Sue - SP7

If Bob and Sue will share a deal, a new number is created:

Bob & Sue - SP8

Every deal they do together goes into the shared number.

On their internal systems, Bob can see the data for SP6 and SP8 and Sue can see the data for SP7 and SP8. That way their individual business is kept completely separate from their joint business and there is no confusion or conflicts.

To take it one step further, contracts can be written and signed by both Bob and Sue as to how on-going commissions, referrals, etc. will be handled for any deals done under SP8.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question