Hi Community,
I am trying to rank based on concatenation of two dimensions and rank doesn't seem to be working.
However, when I remove "group by" condition from rank formula, it ranks. Why is it so?
Can somebody explain please?
Thanks
Alka
Hi @ALKA
The group by column has different values for all the list items. That means there is only 1 item per group element. Hence, the rank becomes 1 for each of them.
Please revisit the grouping and it should work.
Thanks for helping @anikdas , Understood!
Done with the course but want to practice a bit more before I take the Level 1 exam
Has anyone tested Analyst’s response quality/speed on large, sparse models (think 10+ dimensions, millions of line items)? Wondering if there’s a practical ceiling before it starts timing out.
I have a question about the new Expand or collapse grid rows option. Is it possible to publish a grid containing a 5-level hierarchy so that all items from levels 1 and 2 are always visible? And I do not want to use a filter for this.
