Quarter to till date

[Anonymous]

Hi,

How to get a sum from current quarter to till date.

Can you guide me on this.

Regards,

Kumar

[sunny_talwar]

May be using your date field:

Sum({<Date = {"$(='>=' & Date(QuarterStart(Max(Date)), 'YourDateFieldFormatHere') & '<=' & Date(Max(Date), 'YourDateFieldFormatHere'))"}, Quarter, Year, Month, Date, Day>} Sales)

[Anonymous]

Thanks Sunny. In expression is it require Quarter, Year, Month, Date, Day irrespective of YTD,MTD and QTD.

[sunny_talwar]

Those are there so that selection in these fields doesn't impact the expression. Everything should be driven based on DateField.