Im using smart marker approach to create a excel file. In addition to other columns, I have column name "ClosingDate" which has the dates in mm/dd/yyyy format. I want to group the rows based on the year of this column.
How do i do that? How do i use Year funtion in the group
&=Report.ClosingDate(Group:Repeat)
this would not work becuase it will group the rows by date and i want to group them by year part.