Forum Discussion
avleendhanjal
Jan 10, 2023Copper Contributor
How to keep the custom name on a pivot table the same even after filtering it for different columns
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!
No RepliesBe the first to reply