Forum Discussion
Monthly progress representation from annual objective
Hello I need help to make a monthly progress representation I have 4 tables containing the records of 4 forms (Date, Site, Name, etc...) I have 4 annual objectives for these 4 forms of the type "i...
Hi Anonymous ,
If your 4 tables are the same I believe that the best option is not to have 4 different tables but to append them together and have a single table with all the values with a column identifing the form.
If you have single table for the objectives that need to be divided by month believe the best option is to make a relationship between the services and form (not by date) and then using a simple measure like SUM(Table[Objective])/12 you would get the monthly total.
thanks for reply MFelix
Actually, screenshots doesn't show all columns (12-15 kept per form), and some others are different (4 forms , 4 different uses)
so, can't aggregate data tables
I'll try your option for objectives and let you know