@scdecade - Thanks for the attempt. I will look into the approach.

I have finally managed to complete the query.

1. changed the bands to use simple years assuming 2016...

• This reply was modified 4 years, 8 months ago by  Sandeeppunreddy2.

Hi Tyler,

Agreed, it is difficult to get this done using the Pivot. spent a lot of time trying to get that work.

and Yes, it is possible for a student to...

Hi Jeff,

The years are basically enrollment years like the medical enrollment years provided by employers to their employees which can start from any month of the year but usually are...

• This reply was modified 4 years, 8 months ago by  Sandeeppunreddy2.
• This reply was modified 4 years, 8 months ago by  Sandeeppunreddy2.
• This reply was modified 4 years, 8 months ago by  Sandeeppunreddy2.