How to keep the custom name on a pivot table the same even after filtering it for different columns

Occasional Visitor

Hello everyone

 

I have created a pivot table and it's going to be used as a dashboard, I will need to filter the columns by selecting the dates I want to be seen depending on what week it is, I would like to keep the column names constant as "Mon", "Tues" etc. After I change the name from "Sum of Mon 1st Jan" to "Mon" manually it stays but when I filter columns for new dates it goes to "Sum of Mon 1st Feb" for example. Is there a way to keep the custom name the same even after filtering as Mon, Tues etc.

 

Thanks!

0 Replies