Dynamic Column Headers in matrix - Report Server
Hi everyone: I would like the matrix headers to be partly static and partly dynamic. Like this below The base structure is simple, I have a fact table, a calendar table and several dimension tables in a star schema. For my part, try the following. 1- Create an order column in the calendar table Orden = YEAR(CALENDARIO[FECHA]) * 100 + MONTH(CALENDARIO[FECHA]) 2- Create a summary table of the fields I need to use as a slicer TablaApoyo = SUMMARIZE( CALENDARIO, CALENDARIO[FINMES], CALENDARIO[Orden], CALENDARIO[Mes]) 3 - Create a measure that if the maximum order field in the calendar table is equal to the maximum order field in the "TablaApoyo" or equal to the maximum order value - 1, then calculate the units. In the case of the month of January, create another if condition, changing the -1 to -89 because the -89 indicates exactly the difference between January and December PRUEBA = IF( MAX(TablaApoyo[Mes] ) = 1, IF( MAX(CALENDARIO[Orden]) IN {MAX(TablaApoyo[Orden]) , MAX(TablaApoyo[Orden]) - 89 , MAX(TablaApoyo[Orden]) - 100}, [Unidades], BLANK() ), IF( MAX(CALENDARIO[Orden]) IN {MAX(TablaApoyo[Orden]) , MAX(TablaApoyo[Orden]) -1, MAX(TablaApoyo[Orden]) -100}, [Unidades], BLANK() ) ) As a result I get the dynamic header but I cannot add the text correctly with this approach. This is the result I appreciate in advance any help you can give me. Here is an example file and i based myself on this video for the solution in part, but it's not what I'm looking for.
