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
Hi, vijayvizzu
You obviously used 'pivot' in your table, and the column name you mentioned is no longer in the table presented at the end. What kind of results do you want to get in the picture you displayed?
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.