So, I'm facing an issue with a Pivot table in Excel.

First, I've got a SQL connection to a source of data that returns a table, Date being a field in this table.

Second, I connect a Pivot table on top of my table.

Then, I put Date as a Column in my Pivot.

Here's the issue: - When I refresh the source, let's say that all dates changes: I used to have 24/04 & 23/04, and now I have 17/04 & 18/04 - I want to always show 17/04 & 18/04, and never show 24/04 & 23/04 as it is not in the data anymore - Thing is, it's either I only show 17/04 & 18/04 if I have data, or I show everything when I tick the box Fields Settings -> Layout & Print -> Show Items with no data

How can I refresh the Columns so my pivot only shows 17/04 & 18/04 and stop showing 24/04 & 23/04 if it's not in the data anymore?

I tried to play with all Fields settings buttons, nothing seems to work. I haven't written any VBA, not sure it could help

0 Answers