I have a flat data source connected to a PivotGrid. I would like to filter the rows on a criteria, but NOT include that field in either the rows/data display of the pivotgrid.
I'd like to be able to configure a footer for the columns of the PivotGrid similar to the capability provided by the ColumnHeaderTemplate configuration.