Not able to get excel like functionality


In case of using ItemsFilter proeprty, when i am using it for more than one column, at that time when i filtered some values in one column and goes to filter of other column , it shows all the values for that particular column instead of showing only values that are currently user can see.. Does anyhave extended this particular functionality in their project and second thing how user can clear all the filters in one go (clicking of specific button that can be added in popup ) ?

Please suggest alternative way or implementation approach for the specified two missing functionality in ItemsFilter .

Thanks in advance.