<p>Does anyone have any experience with a good wpf pivot table control?</p>

DevExpress Grid control
has good pivot functionality. Used it for Winforms a lot. I think the WPF version is also available.