1 Reply Latest reply on Feb 11, 2016 2:18 PM by Tracy Rodgers

    Tooltips for only certain variables?


      Hi all:


      I would like to add a tool tip for my measure that shows the average for that particular category. IE: I have 5 categories, A, B, C, D, E. However, I would like the tool tip to ONLY display for the categories, A, B, and C. Is there someway to do this?



        • 1. Re: Tooltips for only certain variables?
          Tracy Rodgers

          Hi Lisa,


          One way you can do this is by creating a calculated field that includes the information you want to show and a blank for what you don't. For example, if you don't want to show Furniture, it would look like:


          If [Category]="Furniture" then " "

          else [Category]



          Then, place it on your level of detail shelf and edit the tooltip so that it only shows the calculated field.


          Hope this helps!