DYNAMIC FORMULE QLIK SENSE

[jmialoundama]

Hello,

I have a problem with a formula that I want to make dynamic.

I have the following PivotTable and I put a pane that points to my dimension called "CODE". This filter allows the user to choose the code he wants to analyze in the crosstab.

SUM (BALANCE_M.VALUE OF N) - SUM (BALANCE.VALUE M) - SUM (BALANCE_M.CODE SELECTED) + SUM (SELECT BALANCE_Y.CODE)

My formula is:

= Sum ({<CODE = {'681740'}>} [BAI_BALANCE_M]) - sum ({<CODE = {'781740'}>} [BAI_BALANCE_M]) - sum ({<CODE = {'397000'}>} [BAI_BALANCE_M]) + sum ({<{CODE = '397000'}>} [BAI_BALANCE_DEC_Y_1])

This formula is fixed, I wish that this formula is dynamic, that is to say that when the user has like code N = 1234, M = 45742, and CODE = 67940 then the formula automatically changes alone in the table.

Thanks in advance

[Anil_Babu_Samineni]

How is the values are calculating?