DATEDIFF(date_part, date1, date2, [start_of_week])
Returns the difference between
date2expressed in units of
start_of_weekparameter, which you can use to specify which day is to be considered the first day or the week, is optional. Possible values are 'monday', 'tuesday', etc. If it is omitted, the start of week is determined by the data source. See
You will do
Above will give you a number of months for each row
Now write a calculation like below
If month=12 then '12 months'
elseif month > 12 and month <= 36 then '12-36'
Number of records to column & step 2 calculation to Rows
Please mark the answer as CORRECT and HELPFUL if it helps you so that it can help others as well