Notifications
Clear all
Dashboards & Charts
3
Posts
2
Users
0
Reactions
132
Views
Topic starter
Why does my weekly trend pivot table keep adding a "week 1" after I start filtering with the week # slicer? I do not have week 1 in my data. It starts at week 2.
When I originally created the pivot table my data included a week 1 but I deleted those lines and refreshed data. Do I have to create a new pivot table now?
Also it would be great if you could increase the file size upload constraints.
Posted : 03/07/2022 5:58 pm
Hi Bradley,
Welcome to our forum.
Right-click the PivotTable > Options > Data tab. In the drop down for 'retain items deleted from the data source' choose 'none'.
Mynda
Posted : 03/07/2022 11:40 pm
Topic starter
Eggcellent! Thank you!
I bet you get tired of answering the same old questions lol 😉
Posted : 04/07/2022 11:47 am
