value should be by cell no wise in measure

[Suraj_Kendre]

hello all,

thank you in advance.

I have to show value as per cell dimension highlighted above two value are showing correctly by using this exp

Aggr( ( aggr(nodistinct ( sum ((Capacity)/TotalCapacity)*CapacitperMonth),[CELL no])*$(vpara)) , [CELL no])

However, the remaining values are not showing as required; they are being displayed either by model or product, which is not what I need.

I want to show the value for each cell only in its first row, and display null for the rest of the rows within that cell. For the next cell, show the value in the first row and null for the rest, and so on.

Could you please suggest how to achieve this?

[Venus]

Did you try an "If"-Statement?