Hello Everyone
I have a pivot table with a backing data table from start of the year to year to date. This has an associated Pivot Chart.
On the pivot chart the x axis is Date. This automatically shows every date in the data table, including those with 0 entry.
If I add a field filter at the top of the chart for Periods - and select say period 4 - the dates on the x axis continue to show the whole year rather than just Period 4.
Is there a way around this?
many thanks in advance.
I have a pivot table with a backing data table from start of the year to year to date. This has an associated Pivot Chart.
On the pivot chart the x axis is Date. This automatically shows every date in the data table, including those with 0 entry.
If I add a field filter at the top of the chart for Periods - and select say period 4 - the dates on the x axis continue to show the whole year rather than just Period 4.
Is there a way around this?
many thanks in advance.
