The column "name" must match with column "formula"
ex :the Value "Calculation_385057835130777604" must match in column "Formula" and must replace with column "Caption" value
"Calculation_385057835130777604" must change to "Year_Brand"
<tbody>
</tbody><colgroup><col><col><col><col></colgroup>
ex :the Value "Calculation_385057835130777604" must match in column "Formula" and must replace with column "Caption" value
"Calculation_385057835130777604" must change to "Year_Brand"
caption | name | formula | |
Year_Brand | [Calculation_385057835130777604] | if [Parameters].[Parameter 2] = "This year" then [Calculation_385057835129393153] elseif [Parameters].[Parameter 2] = "Current Month" then [Calculation_385057835129593858] else [Calculation_385057835129860099] END | |
Previous Year_ | [Calculation_385057835142270982] | [Parameters].[Parameter 1]-1 | |
ΔPY YTD_Brand | [Calculation_385057835145179143] | SUM([Calculation_385057835130777604])-SUM([Data Shown Filter (copy)]) | |
EU_YTD | [Calculation_385057835146694665] | { FIXED [Month],[SEGMENT] : SUM([Calculation_385057835130777604])} | |
Current Month_prev | [Current Month (copy)] | if year([Month]) = year([Calculation_385057835142270982]) and month([Month]) = month([Parameters].[Year (copy)]) then [Zulassungen] end | |
Previous_Year_Brand | [Data Shown Filter (copy)] | if [Parameters].[Parameter 2] = "This year" then [This year (copy)] elseif [Parameters].[Parameter 2] = "Current Month" then [Current Month (copy)] else [YTD (copy)] END Thanks in advance Regards Rohit |
<tbody>
</tbody><colgroup><col><col><col><col></colgroup>