Forum Discussion

sachintandon84's avatar
sachintandon84
Helper I
6 years ago
Solved

Can't break RANK TIES (cannot use RAND())

Hi,    I need to do a cumulative running total on a non-date measure, and have been able to do this, by creating a dynamic rank measure column (see below), and then another TOPN Measure that uses t...
  • Anonymous's avatar
    Anonymous
    6 years ago

    Here's how to rank correctly on a non-time dimension. Please adjust it to your needs. No randomness necessary.

     

    File attached.

     

    Best

    D