Hover text on headers

[rtr13]

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. 

Thanks!

[sergio0592]

Hi,

Try to overlap the header pivot table with a text object.