Forum Discussion
Dynamic column title with dates
On the one hand, I have the table with the sections of my matrix:
| id | number | scope |
| 1 | Orders in the month to DATE | National |
| 2 | Orders in the month to DATE | Export |
| 3 | Orders in the month to DATE | TOTAL |
| 4 | Orders received on DATE | National |
Then, for each line in that table, I have a measure that calculated the amount.
Once I have all the measurements, I make the matrix:
Measure "Apartado_ordinatto 3" is as follows:
Apartado_Ordinatto 3 = SWITCH([apartado_ped_selec3],
1,[Ped_En_El_Mes_Hasta_NACIONAL],
2,[Ped_En_El_Mes_Hasta_EXPORT],
3,[Ped_En_El_Mes_Hasta],
4,[Ped_Recibidos_el_NACIONAL],
It is a switch that binds the id to its respective measure to create the array. The problem is that in the matrix, in columns I put the column name of the table but as you can see, it is a title that should change according to the filter that is put in the date reclassification.
Also, if the title is "Orders in the month to DATE" it should be changed to Orders in the month to 13/10/2023 (this is an example.)
Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.