Scenario
The user may want to to show as a separate column this month, last month, same month last year, last month to date in the Saved Search.
Solution
To show as a separate column in a Transaction search, Last Month, Same Month Last Year and Last Month to Date:
Assumption : Today = July 15 2019
This Month (July 2019)
Formula (Currency) | Sum | case when to_char({trandate},'mm/yyyy') = to_char({today},'mm/yyyy') then {amount} end | This Month
Last Month (June 2019)
Formula (Currency) | Sum | decode(trunc({trandate},'month'),trunc(add_months({today},-1),'month'),{amount},0) | Last Month
Same Month Last Year (July 2018)
Formula (Currency) | Sum | decode(trunc({trandate},'month'),trunc(add_months({today},-12),'month'),{amount},0) | Same Month Last Year
Last Month to Date (June 1 2019 to July 15 2019)
Formula (Currency) | Sum | case when {trandate} between trunc(add_months({today},-1),'month') and add_months({today},-1) then {amount} else 0 end | Last Month to Date