Thread: [Solved] Pivot table not picking up the data from source
View Single Post
 
Old 01-10-2023, 06:51 PM
Marcia's Avatar
Marcia Marcia is offline Windows 11 Office 2021
Expert
  
Join Date: May 2018
Location: Philippines
Posts: 551
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default Pivot table not picking up the data from source
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.
Reply With Quote