Filtering and Pivot Table

I have created a table, and I choose to filter information from only the last week. When I create a pivot table from the filtered information, the pivot table extracting info from the whole original table not the filtered info. What am I doing wrong?

Please Login or Register  to view this content.

You don't add the file, without confidential information.

I add an column to determine the week.

After that I made an pivot table.

See the attached file.

Please reply.