I've never once used a pivot table, so I can't be of any help on that part.

For the multiple selection part, maybe look at this:

http://blog.contextures.com/archives...lidation-list/