I would like to be able to make a custom column (on the highest parent level e.g. Year) and replicate it throughout the other years when selected. The measure within the custom column should be a calculation measure. For instance; I have amount measure in my accoplanning with a total and then the amount throughout the months (and year) however one year selected at a time. Here you are able to writeback. Now I would like another total column for benchmark that should be non-writeable. But I do not what the benchmark measure to be shown throughout the months, only year. When I place the benchmark measure and hide the coulmns thoughout the months it is only hidden in the selected year. When I make a custom calculation with the benchmark the settings do not follow when I change years.
Is it possible to be able to replicate a custom column on the highest parent level based on a calculation measure so no matter what year you choose the total benchmark is shown and not thoughout the month?