problem with set analysis

[zied_ahmed1]

Hello,

I would lik when i select a Month i will have the sum of CAT from the start of year to Month selected :

For example if i select April i will do sum of January,February,March,April of sum (Sales)

Thanks for help

[arvind_patil]

Hi Zied,

Your Set analysis may be like below:

Sum({<Date={'>= $(=YearStart(max(Date))) <= $(=max(Date))'},Month=>}Sales)

Thanks,

Arvind Patil

[shraddha_g]

try this,

sum({<Date = {">=$(=date(Yearstart(Max(Date))))<=$(=Date(max(Date)))"},Month=>}CAT)

[zied_ahmed1]

Hello,

I will explain more the requirement :

If I select June i will have the sum Sales of A16-06 (06 is the June ) and 05 and 06 of the field CAT

[arvind_patil]

Hi Zied,

At the time of selection of month june  your max date is jun 18.

sum({<Date = {">=$(=date(Yearstart(Max(Date))))<=$(=Date(max(Date)))"},Month=>}CAT)

Yearstart gives you from jan to june.

Thanks,

Arvind patil

[shraddha_g]

what is the year in this case?

Create a date field and then use that set expression mentioned in previous comment.

[balabhaskarqlik]

May be this:

Sum({<Month = {"$(='>=1<=' & Num(Month(Max({1}Date))))"}, Year>} Sales)

[balabhaskarqlik]

Refer this:

Sum 12 months data according to the selected period