Hi all. I'm going nuts from a pivot table results. The workbook contains tables from 2021 and 2022. One table in one sheet is FY2021, while another table in another sheet is 2022. The headings of both tables are the same. I created a pivot table with FY2022 as the source but it is showing the data from FY2021 not FY2022. Any idea what is causing the wrong information?
Thank you.

I solved the problem by deleting all the pivot tables previously created in FY 2021.

An excellent example why it is better to keep all data with similar structure in single table!

Had you did so (and added a Year column), you could add a filter for year to your pivot, and then you could select any year in your source table you want the pivot for, and you'd get it!