Set analysis of % contribution

[DGAL1]

How do i write the % contribution of the top 3 months towards their own

total in qlik sense , below is the screenshot of the excel i calculated  on my own

[TheoAtragie]

Try this :

sum({<MONTH={"=aggr(rank([Total sales],1,1),MONTH)<=3"}>} sales) /

sum({<MONTH={"=aggr(rank([Total sales],1,1),MONTH)<=3"}>} TOTAL sales)

Kind regards,
Théo ATRAGIE.

[Chanty4u]

Try this

Sum({< %Date = {"=Rank(Sum(QM)) <= 3"}>} QM) / Sum(TOTAL<QM> QM)

[TheoAtragie]

This formula will give the % over all months only for the first 3 months. To reproduce the fourth column of the attached table, the set analysis must be extended from the numerator to the denominator.

Kind regards,
Théo ATRAGIE.

[TheoAtragie]

In the attached table it was the top per month, hence the formula.
Can you assign a solution to one of the answers in order to close the topic?