I have a very annoying problem. When I apply a filter on design this filter does not work propertly:
In running the app the filter is applied and filtering but when I open the filter window and I change this filter it does not change the results.
I have seen that when I change the filter options running the app the filter collection (RadPivotGrid1.Filters) still has the previous filter.
I set the filter to DoesNotInclude and filter value 0 then running the app I set the filter to Include and filter value 0, the rows doesn't change and the filter collection shows as you can see in the QuickWatch result attached file the previous filter is not deleted so the new filter does not work.
Is there any way to solve this? Is there a method fired when the filter change to delete the previous filter?