Hi!
So as stated, I have a Pivot report showing records by year. The records are in the Pivot Table; but the report only displays records through 2014.
Any ideas?
Christina
Hi!
So as stated, I have a Pivot report showing records by year. The records are in the Pivot Table; but the report only displays records through 2014.
Any ideas?
Christina
Can you post your file?
Hi Christina and welcome to the forum,
You need to expand the range of data that your Pivot Table is using. Click on the Pivot Table and then on the Tab called Pivot Table Tools. Next under the "Pivot table tools" click on the "Analyze" tab. In the Data group click on "Change Data Source" and see if the new data is included in the range. If not then increase the range so the new data is in it. If that isn't the answer you need to REFRESH the pivot table data which is the icon to the left of the one above.
See if that works for you. If not then let us know, so we can suggest something else.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
THe file was too large to upload (3 MB) so you can find it at this link:
-Christina
Last edited by dixiecricket; 06-16-2015 at 11:25 AM.
Yes, the records are included in the data group for the report
-Christina
Because there is no data for any year beyond 2015.
But there is data for 2015 in the pivot table - the report just doesn't pull it over
Change your source data to Sheet1!$A:$DO instead of Sheet1!$A:$DQ
I cannot believe that worked!
Thank you, JieJenn! I knew it had to be something incredibly simple.
Christina
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks