Previous Month Data

[#1]

Hi All,

how do i create a report for just showing only

Data for previous month while we are on current month

e.g Sales,Date

by using addmonths function or any logic that can be applied.

Thanks.

[tresesco]

Similar discussion here: Retrieving previous months data based on selection

[MK_QSL]

=SUM({<InvoiceMonth=, InvoiceYear=, InvoiceQuarter=,  InvoiceDate = {">=$(=Date(MonthStart(Today(),-1)))<=$(=Date(MonthEnd(Today(),-1)))"}>}Sales)

Change Fieldnames accordingly...

[#4]

Hi All,

Thanks it works i used the solution for Manish!!

Thanks alot.

[sasiparupudi1]

Please close this thread by marking a correct answer so that it will be helpful for others