In order to show the cout crate a saved search by following the steps below
To create the search, perform the following steps:
- Navigate to Lists > Search > Saved Searches > New.
- Select Activity.
- Provide a Search Title.
- On the Results tab > Columns subtab, set the following:
- Select Formula field type numeric and use “DECODE (to_char({createddate}, 'MM'), '01' , 1)” function for the first month
- For remaining months change above highlighted area like below.
- February: DECODE (to_char({createddate}, 'MM'), '02' , 1)
- March: DECODE (to_char({createddate}, 'MM'), '03' , 1) and so on use custom label for naming months
- Search results will be as follows: