Advanced filter not applying to the summary section of the compensation worksheet

Summary:

Advanced filter not applying to the summary section of the compensation worksheet

Content (please ensure you mask any confidential information):

Hi Experts,

We have a requirement to check the summary based on Grades DFF filter. So we have added the user-defined column to pull the Grade level DFF and used the same in advanced filter.

When we search the worksheet data based on the advanced filter the table results are showing as expected, however the same is not applying to the summary section. So summary table and graph (performance summary) not changing based on the worksheet table result.

Could you please share your inputs to achieve this requirement.