Hi,
I have a pivot chart where i'm showing sum of study credits earned by a student per study year. I have a "master" calender that is associated with date of registration of the study, and this calender includes the study year used as a dimension in the chart.
In my model there is also data about the presence of the student for the study year (present or absent). However this data is not linked to the "master" calender due other reason within the file.
What I would like to add to the chart, is that if the the sum of the earned study credits in zero and the the student was absent during the spesific study year, a text 'Absent' would show in the presentation. If the student was present, but earned zero credits, a zero or line would be shown. However i cannot find a way to do this as the study year of the earned study is not associated with the precense of the study year.
Example what i'm aiming for:
| Student number | 2008-2009 | 2009-2010 | 2010-2011 | 2011-2012 |
|---|
| 234242 | 30 | - | Absent | 23 |
| 563453453 | Absent | Absent | 14 | 35 |
I was looking in triggers (like when sheet was activated, the study year of the earned study and the study year of presence would be the same) but couldn't find anything helpfull.
Is there a way to do this without linking the study years of the student presence in to the master calender?
Thanks alot!!
There is only one calender, but also another time period.