Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Experts,
would you please help the followings:
please check the testing data attached.
Can i change the DOS in Total in RED color, pick the largest month DOS, not sum up all month? so does the blue field...
i try Dimensionality(), it doesn't work.
would you please kindly help with this?
Thanks,
Best regards,
Manie
Anyone HELP??????
Hi
This works, if I understand you correctly
=If(Dimensionality() = 0 And SecondaryDimensionality() = 0,
Max(Aggr(SUM(DSO), YEAR, MONTH)),
SUM(DSO)
)
HTH
Jonathan
Dear Jonathan, it seems doesn't work. what i want the result is like the follow pic:
would you please help...?
thanks,
best regards,
Manie
Help help help experts~~~~
A small correction in Jonathan's formula:
=If(Dimensionality() = 0 And SecondaryDimensionality() = 0,
Max(Aggr( Sum(DSO),YEAR,OSR)),
SUM(DSO)
)