how do i rank this?

[amien]

rank(

sum( {$< Month = {"<= $(=Max(Month))"}>} (((value1*value2)/vale3)/10))/Max(Month)

)

this works when i only have material_ID as dimension. When i put both material_ID and material_descriptions as dimensions, all values of the above expression will be 1 .. how can is solve this? i need two dimensions

[swuehl · Accepted solution]

Hi Amien,

probably your dimensions result in a single record per combination of dimensions?

Try using the TOTAL qualifier, maybe

rank( TOTAL

sum( {$< Month = {"<= $(=Max(Month))"}>} (((value1*value2)/vale3)/10))/Max(Month)

)

Regards,

Stefan

[tmumaw]

Create a concatinate key with your material and description and rank on that.