Day wise Current Month & Last Month Comparison...........??

[aveeeeeee7en]

Hi Experts

I need some help on Comparative Analysis............!!

Please go through the Attachment to see my Requirement.....????

Regards

Av7eN

[Anonymous]

so you basically want to see last 4 weeks no matter month and date etc right ?

I think you can use

date greater than equal to monthstart(today())-28  and less than monthstart(today())

for previous months data

regards,

Bhagirath

[aveeeeeee7en]

Need Suggestions????

[Anonymous]

=SUM({<Date={'<$(dayname(monthstart(today())))'},Date={'>=$(dayname(monthstart(today())-28))'},Date=,MonthYear=>}Amount)

[giakoum]

Bhagirath gave you the solution. What more do you need?

=SUM({<Date={'>=$(=monthstart(today())-28)<=$(=monthstart(today()))'}>}Amount)