Calculating Last & Current Month Sales

[#1]

Hi Experts

I am Currently using a Straight Table

Doing a resident load to choose top 10 sales for each Branch

But stuck in calculating Current Month Sales & Last month Sales

Please Suggest

[sunny_talwar]

I don't see this variable vMaxSalesDate in the variable overview. How do you define that variable?

=Date(MONTHSTART(AddMonths(vMaxSalesDate, -1)))

[#3]

HI Sunnindia

Sorry I missed it

vMaxSalesDate =Date(Max(DEC_Date))

[sunny_talwar]

Seems to be working once I put the variable definition in the application. Does this look like what you wanted?

[#5]

HI

Yes, But still not showing any results on my original Qvw with the variables

Thank You For  Pointing out

[sunny_talwar]

May be caused by another problem? Not sure how to troubleshoot your sample when it is giving the output. You want to explain what is going wrong?