http://www.google.com/search?q=pivot+table+discarded+due+to+integrity+problems leads to something useful.

Note I've corrected your spelling. And the word "being" doesn't seem to belong in the message either. If you ever post again for another problem (that's what we are for), please pay attention to details like that. It's much easier to find a solution if you're looking for the right thing.

Kees