Hi all,
in my scenario a student can take different Modules. For an example I have these Modules:
AH10
AH11
AH12
BL20
BL21
BL30
BL32
When a user select from a list box AH10, I would like to create a set analysis where I would count the number of students taking this module compared with all AH1 modules.
So, what I would like to eventually get should look like:
Count({Grade,Module={"$(=vModuleCode)"}}Student) / Count ({Grade,Module={"$(=vModuleCodeALL)"}}Student)
As you can see I have already created a variable for the selected module vModuleCode and I would like to create a similar variable where I would like to store all values for Modules from the same 'category'. So if user selects a module AH10, then in the vModuleCodeALL variable should be assigned values AH10,AH11,AH12.
Any suggestions?
