For a field to appear in a tool tip, it has to be somewhere in the view. Often times, simply placing it on the level of detail shelf will allow you to add it to the tool tip without it influencing the view.
Hope this helps!
Thanks Tracy for your response. I already tried this but this is influencing my view for 2 statues
- Normal status with errors within 1%
- Warning status with errors upto 5%.
In both the cases the status breaks down into 2 parts - Normal & Error.
I also tried creation of errors set & placing that on to the row shelf & making show header off; but this also not helped me. I can create a different worksheet to display the erros but the requirement is to show error message in tooltip.
Would it be possible for you to attach the workbook that you are using?