I have created 2 pivot table--one for 2006 and one for 2007 as this was the
easiest way to filter through alot of data. My objective is to see how many
new ship to's ordered in 2006 vs. 2007. Any ship to's that have not ordered
show 0 dollar value.

2006 2007
ship to amount ship to amount
321 500 326 250
326 0 321 0
334 250 344 100

I also used a formula in the ship to fields to combine the ship to code with
the city and state so the ship to cells would read 321-greenville, sc.
I want to see how many more ship to's ordered in 2007 vs. 2006. After, I see
the total NUMBER of new ship to's that have ordered, I'd like to be able to
create a percentage.
I'd also like to see how many ship-to's in 2006 have not placed an order in
2007.

Also, my rows are not aligned. I'd like to be able to see ship-to 321 in
2006 next to ship to 321 in 2007. Is there a way to do this. Remember, that
there are some ship to's on the 2006 list that are not on the 2007 and vise
versa.

What are the formulas I can use?