Does anyone know how to add hover text onto headers within a pivot table? I have tried to input an if statement as followed:
=if(Header='Previous Year','Previous Year' &chr(13)&chr(13)&chr(13)&'The previous rolling 12 months: '&pstartdate&'to'&penddate, if(Header='Current Year','Current Year' &chr(13)&chr(13)&chr(13)&'The current rolling 12 months: '&cstartdate&'to'&cenddate))
But, with I do this i get the ... after the header which I am looking to avoid. Is there a way to add hover text without getting the ... after the header? I appreciate the help.
