I want automated report as given in screenshot.

[Anonymous]

Hi all,

I want automated report for the month of April, May, Jun, Jul, Aug, Sept, Oct, Nov, Dec, Jan,Feb,Mar, MTD, YTD and yesterdays data. in one table.

I have made a report for the above requirement but after every month I have to change the number  in expression.

eg:

Sum( {<Date={">=($=Date(MonthStart(AddMonths(Today()-1,-10)),'DD-MM-YYYY'))

                         <= ($=Date(MonthEnd(AddMonths(Today()-1,-10)),'DD-MM-YYYY')) "}

          >}

     GWP)

Every next month I have to change the number i.e ( I have to adjust the no 10 accordingly.)

PLease help.

Please find the attachment for reference.

[vishsaggi]

CHeck this below link

Date Level Analysis - WTD, MTD, QTD &amp; YTD (Current Year &amp; Previous Year)

[Anonymous]

Can you please send the QVW and excel which you had sent before this reply.

[Anonymous]

Please help ,

I have made this report,

I want to make automated.

[vishsaggi]

I did not upload any qvw file? Not sure what you talking about?