@Zack_Snyder unfortunately that doesn't solve my need. When I mentioned "Enabling the ability to have a filter control in the interface which is referenced by the pivot table", I was referring to dynamic filtering within the interface, like you can d...

It's frustrating there isn't a way to filter down the data. What I want to do (and currently can't) could be accomplished either by:Enabling the ability to group by more than 1 field, orEnabling the ability to have a filter control in the interface w...