Hi Sakthi,

I Hope this is your view look like

Create a calculated field like below

East Profit:

{Exclude [Region]:SUM(

{Fixed [Region],YEAR([Order Date]):

SUM(If [Region]="East" THEN [Sales] END)}

)

}

Place it in Tool tip:

Arrange your  tool tip like below:

You Will get the Desired Output

Hover over Central Region:

Hope this helps. Plz mark this answer as correct or helpful to close the thread

BR,

NB

You can create a simple LOD calculation and add it to the tooltip as shown below:

Hope this helps.

You are welcome.