I am stuck in the scenario where in i have to dynamically change the current month.
Below is the scenario of the same:
1. I have a column called Current Month which have certain values.
2. This column when added into the report table it should show the name of the Prev Month and the Year.
3. I have made certain Transformation which helped me to get the the Prev Month and Year as the Name of the Column, but whenever i change the data/Month name gets changed I have to manuall insert the column into the Table at report level.
Is there any work around for same as this is urgently required by the client and no manual intervention is required.