Here is the script...
First, load the data source into one table. I'll call mine "MyTable".
Then use this...
MonthGoals:
CrossTable (Month_name, Month_goals)
Load
MyKeyField, // This is the field that tells you what it's for, ex., EmployeeID, Department
Jan20,
Feb20,
Mar20,
Apr-20,
May20,
Jun20,
Jul20,
Aug20,
Sep20,
Oct20,
Nov20,
Dec20
Resident MyTable; // Or whatever your data source is
QuarterGoals:
CrossTable (Quarter_name, Quarter_goals)
Load
MyKeyField, // This is the field that tells you what it's for, ex., EmployeeID, Department
Q1-20,
Q2-20,
Q3-20,
Q4-20
Resident MyTable; // Or whatever your data source is
Drop Table MyTable;
This will create two tables MonthGoals and QuarterGoals.
Month Goals contains the month name in Month_name and the goal in Month_goals.
Quarter Goals contains the quarter name in Quarter_name and the goal in Quarter_goals.
If you have more than one key field then use
Crosstable((Month_name, Month_goals, n)
where "n" is the number of key fields. Then list those fields first. For instance, if you had Department and Employee then you'd use
CrossTable (Month_name, Month_goals, 2)
Load
Department,
Employee,
Jan20,
Feb20,
.
.
etc.....
I hope this helps. Check out my blog at QlikWithFriends.com.
