Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Did you try an "If"-Statement?