Hi all,
So I am somewhat at a loss on how to resolve my current issue.
I have created a pivot table with my data included within a data model. The purpose was so that I could create a date table and link this connection to get my data to show 22/23 data in order etc. as my raw data was in days and didn't do what I needed it to..
So having looked up how to do this, and successfully completed this element, I am now faced with an issue where for whatever reason, any new data after the current date input i.e. I have data to the 9th March and added a new row in the raw data for the 10th march, that on a data refresh, the data isnt being pulled into the pivot.
Additionally I cannot seem to use the "PivotTable Analyze" option in excel to change the source data as it's greyed out...
Any help or suggestions would be appreciated.
So I am somewhat at a loss on how to resolve my current issue.
I have created a pivot table with my data included within a data model. The purpose was so that I could create a date table and link this connection to get my data to show 22/23 data in order etc. as my raw data was in days and didn't do what I needed it to..
So having looked up how to do this, and successfully completed this element, I am now faced with an issue where for whatever reason, any new data after the current date input i.e. I have data to the 9th March and added a new row in the raw data for the 10th march, that on a data refresh, the data isnt being pulled into the pivot.
Additionally I cannot seem to use the "PivotTable Analyze" option in excel to change the source data as it's greyed out...
Any help or suggestions would be appreciated.