Concatenate a selection, i.e Month and Month YTD

TM1 has been so successful over the years, not just thanks to its powerful calculation engine but also thanks to its very mature Excel add-in, Perspectives. With Perspectives, you can slice your data from a cube into Excel and then you have the freedom to customize your report by adding formulas or conditional formatting. Perspective uses proper Excel formulas which are very easy to use such as SUBNM to get a list of elements or DBR to get a value from a cube.