Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot table with DSO issue

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?

2014-11-18_10-01-09.png

Thanks,

Best regards,

Manie

5 Replies
Not applicable
Author

Anyone HELP??????

jonathandienst
Partner - Champion III
Partner - Champion III

Hi

This works, if I understand you correctly

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

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

  SUM(DSO)

)

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable
Author

Dear Jonathan, it seems doesn't work. what i want the result is like the follow pic:

2014-11-18_14-29-44.png

would you please help...?

thanks,

best regards,

Manie

Not applicable
Author

Help help help experts~~~~

tresesco
MVP
MVP

A small correction in Jonathan's formula:

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

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

  SUM(DSO)

)