Hi Han,
FYI, I nuked your other thread, as it was a duplicate. I do appreciate that you posted in the PivotTable forum with the other thread, but no need to post it in two place. We can deal with it here.
Can you do us a favour and upload some sample data that we can look at? Mock it up, or do a find/replace to remove anything sensitive. The closer it is to reality the more it will help us determine the right path though.
Bookmarks