Stacked barchart tooltips

[Anonymous]

Hi, 

Is it possible to have a hide one part of tooltips and only show have one shows on this bar chart and if so how ? example below ; I want to have a tooltip show for blue and not yellow.

I have two measures on value filed, yellow present loss and blue present gain. 

[Greg_Deckler]

Perhaps something like:

Measure 3 = 
IF(MAX([Column1])="Cat1",BLANK(),SUM([Column2]))

And use that for your tooltip.

[Anonymous]

,

thanks for your reply,

I have tried to use your solution but i seem to have trouble with code,

you suggested

Measure 3 =
IF(MAX([Column1])="Cat1",BLANK(),SUM([Column2]))

I matched it to my report as

Measure 3 =
IF(MAX([bluebar])="Cat1",BLANK(),SUM([ .............

but the "yellowbar" measure not coming up for the second part of the code ??

what cat1 stand for ?

thanks