How to group by formatted date column Analysis

Summary:

Hi,

we create analysis to count PO created yearly, so create Analysis include bill-to-location, creation date columns ,we want to group by bill-to-location, creation date , for bill to location it is fine,

the issue is to group by Creation date in format like to_char('Creation Date','YYYY')

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):