How can we use Rank value in another calculation in SAP Analytics Cloud.

[former_member744134]

I am working on ABC analysis and want to have %Product which is (Rank number/ count(Product)). For example value of Top 2 is 2 and count of product say 10 then %Product = 2/10.
How can I use Rank number to use in %Product formula in SAP Analytics Cloud. Any clue would be helpful.

Regards
Arvind

[sharonzhou]

Hi Sharma,

There is a workaround that may solve your problem: In the BI table of SAC, you can add calculation - Rank Number to the table by right-clicking an account member.

Then you can use the rank value to do the further calculation in the table(screenshots have no business significance, only for explaining this workaround):

A normal account member(Sales) and a calculated account member both work in this case. Please note the "Rank Number" and "Rank Number/Sales" are on-the-fly calculated results that cannot be reused in other places of the story.

Hope it helps.

Best,

Sharon

[former_member744134]

Thanks Sharon for your detailed explanation, will try this.

Regards

Arvind