topcount and bottomcount function in a relational model

[reginoilano]

Hi,

I used a topcount and bottomcount function to get a dynamic ranking in a list report, but when I tried to create a condition where the ranking will be based on the user input whether it is a top or bottom an error occured stating that it is not supported.

in one data item I created the logic expression:

Case
  when (?rank format?='Top') Then
    (topcount([subject],?rank limit?,[amount])
  when (?rank format?='Bottom') Then
    (bottomcount([subject],?rank limit?,[amount])
End

anyone had experience this situation?

Thanks!

[laks]

What kind of error your getting. Check your syntax, you didn't closed the parentheses which opened before topcount and bottom count.

[eliza_jane]

TopCount and BottomCount functions are to be used with DMR or Dimensional models only and not relational models.