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!
What kind of error your getting. Check your syntax, you didn't closed the parentheses which opened before topcount and bottom count.
TopCount and BottomCount functions are to be used with DMR or Dimensional models only and not relational models.