Qlik Sense rank issue

[Caroligian]

Hi all,

I need to make the transition from an excel file, and in this excel file the rank funtion used is this:  =RANK(X3,O3:X3,0)

I have to make a straight table which besides the data I have a rank column. The problem is that it should be made up of several sets of analysys. 

I have ten fiscal quarters in the form of  this formula : 

=sum({<NrRand={$(vMaxFQ1)}>}[Ref Sellout Deal Net CLC])/sum(TOTAL<[Reporter HQ Organization],[Current Product Segment],[Month]>{<NrRand={$(vMaxFQ1)},[PEA Partner flag]=, [Reporter Partnername]=>}[Ref Sellout Deal Net CLC])

I tried a lot of things but they did not work.

How i can made this in qlik?

Thanks in advance.