Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
How is the values are calculating?