1 of 1 people found this helpful
you need to pivot the data to form a tall narrow dataset
see the link Pivot Data from Columns to Rows
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Follow below steps after connecting to database,
Select all months and apply pivot.
Select only months and apply Pivot and rename F1 column to Year.
Finally, Apply Concatenation in calculated field of Year and Pivot Field Name
Create a calculated field like below.
Date issue.twbx 18.0 KB