I am trying to display the top reasons students complete internships. I am using a set I created as ReasonsForInternshipSet. I can filter Top N 3 at all levels of semester, college, and major, but it will only display 1-3 values if they are consistent with the top n table level values. otherwise it won't show anything and even hides filtered values that don't have the top 3 present.
I am also attaching a workbook. The sheet in question is TOPREASONS_AY.
1 answer
The reasons are getting pre-filtered for the top 3 values by having it as part of a set and are not dynamic in nature. You should look at not using a set here and instead create a filter to get you the top 3 reasons while ensuring that all the filters are added to context.
