Problems with Topcount()

• Nick081

  Old Hand

  Points: 351

  More actions

  May 7, 2008 at 3:43 am

  #190023

  Hello,

  I would like to get my Top 10 Accounts, and therefore I'm using the function "TopCount"

  This is my formula:

  TOPCOUNT([Dim Account Base].[Account Name].Members, 10, [Measures].[Estimated Revenue])

  The output of this is (NULL), could anybody explain to me what I'm doing wrong.

  Thanks!

• Pete Brown

  SSC Eights!

  Points: 984

  More actions

  May 8, 2008 at 3:11 am

  #812302

  The TopCount function looks at a 'set' and then takes your selected 'count' and applies it to this set for your selected 'measure'.

  However a 'set' has to be enclosed in curly brackets (MDX syntax requirements)

  Therefore if you change the code to the following hopefully it should now work.

  TOPCOUNT( {[Dim Account Base].[Account Name].Members} , 10, [Measures].[Estimated Revenue])