How to block sort column in straigh table

[sdavinblanc]

Hello,

After a long search, I finally figured out how to calculate the evolution between [nb_allowed] at a reference date and each other years (rows) in my table (see attached file).
Here's my formula in Qlik Sense : (Top(Sum([#Nb_Allowed]))-Sum([#Nb_Allowed]))/Sum([#Nb_Allowed])

Excel file example calcul for C3 :  (B2-B3)/B3

Unfortunately, if the user changes the order of YearMonth (column A), my calculation no longer works because the first row of the table no longer contains the reference date.

Is there a way to block sorting column ?

Thanks you for your help !

[Or]

Have a look at this for a partial solution:

https://community.qlik.com/t5/App-Development/Qlik-Sense-how-to-disable-sort-feature-on-straight-tab...

[sdavinblanc]

Hello @Or 

Not sure to understand what is the partial solution, i've tried to use Above but it's still possible for the user to sort the column so at this end my calcul is wrong because the reference date is at the bottom of the table and not at the top anymore...