Forum Discussion
Solved
Dynamic update column names
Hi, I have a monthly budget table contains project id, Jan Budget, Jan Forecast and so on till Dec. Each month will have two columns Budget and Forecast, whenever the month passed, we will rename For...
vijayvizzu , first unpivot this table and then try to use it
vijayvizzu
The first point I note here is that you should never have pivoted data in your tables, it should always be in unpivoted format. Jan, Feb, etc. are not supposed to be columns they must be in a column named Month Names, preferably in a date table. SAme goes with actual and forecast could be arranged in columns. Please refer to these videos on how to handle them:
https://www.youtube.com/watch?v=Vff2kRBM95o