Pivot table with DSO issue

[#1]

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

[#2]

Anyone HELP??????

[jonathandienst]

Hi

This works, if I understand you correctly

=If(Dimensionality() = 0 And SecondaryDimensionality() = 0,

  Max(Aggr(SUM(DSO), YEAR, MONTH)),

  SUM(DSO)

)

HTH

Jonathan

[#4]

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

[#5]

Help help help experts~~~~

[tresesco]

A small correction in Jonathan's formula:

=If(Dimensionality() = 0 And SecondaryDimensionality() = 0,

  Max(Aggr( Sum(DSO),YEAR,OSR)),

  SUM(DSO)

)