Cube View Running Sum
Please see this post from Adam. Posting on his behalf. I also want to know the answer to this.
Forum Discussion
Formula should look like this. IMPORTANT: Change lines 33/35 from E# to U1# for your case, and also change line 38 from api.Pov.Entity.Name to api.pov.UD1.Name , since you are using UD1 for ranking.
IMPORANT: the lstRankedNames must be of type Shared (so it gets shared across multiple instances) , and it must also be declared in the "Helper Functions" area of the code editor. This assumes you have adapted your XFBR or XFR Business Rule to write the "Rank" list to the SessionState (back in part 1) of this answer.