1 of 1 people found this helpful
In this situation, I would recommend using a forumla like:
IF ATTR([Name])=LOOKUP(ATTR([Name]),-1) THEN
from your current view, with a compute using of Table (Down), and then if you need to move the pills, first use the "Show Me" button to lock in this current layout based partitioning.
attached is an example.
Thanks for that. That one looks like it works. I have one more ranking question.
I have the situation when I want to refer to ranks in previous periods. In the previous periods I can't get the ranks to stay, they always move as per my current sorting. Is there anyway around this? E.g. see example workbook (here for week 1 I want the rank to be 3,2,1).
Nathan, I believe you can achieve what you are looking for if you can explain it more detail. Can you detail the logic you want to use and the result you expect? currently it is not clear to me.
Thanks for your response. In the example in the attached workbook -
I want a rank for each period. This should rank the names in descending order of dollar amount. I want this rank to be static (so that when I e.g. add dimensions it stays). To date I have only used INDEX() for rank which is dynamic, so does not work for this.
Does that make sense? Appreciate your input.
I am sorry, that does not make sense to me.
Table calculations like Index() are based on the marks in your view, and those marks are based on the dimension pills you have in use, so when you change your pills, the table calculations can change because they are data driven. If you know what dimensions you want to use in the view, you can craft your table calculations to take these changes into consideration and get the results that you want.