topic Rank in hierarchy in App Development

Rank in hierarchy

bensca04 — Wed, 16 Feb 2022 12:12:17 GMT

Hi folks,

maybe someone can help with a rank-problem.

I have a table of customer-hierarchy, which I want to rank. This rank should get any customer of the hierarchy.

Example:

But now I need the following table:

What is the formula?

I tryed (not succesfully): aggr(rank(-sum(Sales),4),Hierarchy)

Thanks for your ideas in advance!

SBDataspark — Mon, 21 Feb 2022 16:42:06 GMT

Hi there,

Would you be able to provide a small set of data to experiment with?

Kind regards,

Sebb

AnalyticsBoost — Wed, 23 Feb 2022 12:58:33 GMT

Formula could something like this: Aggr(nodistinct Num(Rank(Total Sum(Sales),4)),Hierarchy)

bensca04 — Wed, 23 Feb 2022 13:57:36 GMT

Thanks @AnalyticsBoost ; thats it. The "nondistinct" was the solution.