In our PivotGrid control, we have provided support to
filter values from column and rows using text filters with the help of filter
popups available in grouping bar header areas. Also, we have provided the
support to perform advanced filtering and sorting using same filter popup as
same as in MS Excel. With the help our advanced filtering support, user can
apply label and value filters for our control. When we are trying to filter the
values using either text filters or advanced filters, it takes little bit more
time to complete the action compared to filtering feature in MS Excel. Hence,
we need to improve our filtering performance which is closer to the filtering
performance of MS Excel.