Calculating the percentile for each member of a dimension

Answered

Comments

2 comments

  • Avatar
    Sam Ovenshine

    Hi Michael,

    Take a look at my screenshot below. I'm getting the max rank with this formula:

    (DUPcount([ProductName]),ALL([ProductName]))

    The ALL function lets you get a value for all ProductNames, not just a single row's ProductName.

    1
    Comment actions Permalink
  • Avatar
    Michael Cowley

    Thanks Sam! I had to use COUNT instead of DUPCOUNT to get the expected results, but that's working perfectly for me. Much appreciated!

    0
    Comment actions Permalink

Please sign in to leave a comment.