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!
Monitoring the size of the workspace is crucial in Anaplan, since you must not exceed the allocated size. In general, what advice do you have? Thank you Julien
Hi, I'm working on some data that I'd like to present as a cascade chart, but I have no idea how to do it. Unless I'm mistaken, this type of chart isn't available by default. Do you have any tips or advice? Any examples? Thanks in advance, Julien
Facing challange to get the exact totals for Q1 Q2 line items(it should be 21250), Can somebody please suggest a way to get subtotals intead of grand totals. My Summary should be dynamic.