Set Analyis with current month and previous month

[tripatirao]

Dear All,

Please help me find out the required output.

I have attached the output what i want and the source file.

And also want the YTD value of corrosponding product.

Please do the needful.

Regards

Tripati

[Anonymous]

Try :

expression:

Sum( {<Year=,Month= ,Week =,Day=, DataNum={">=$(=Num(YearStart(Today())))<=$(=Num(Today()))"}>} Sales)

Check aswell:

Previous YTQ, QTD, MTD and WTD

Regards,

Grzegorz

[sunny_talwar · Accepted solution]

This doesn't match you exact output, but is this what you were looking to get?

[miskin_m]

Hi,

try below

sum(Sales)-sum(aggr(above(sum(Sales)),Product,date))

Regards,

[tripatirao]

Dear Sunny,

Thanks for reply.

This is some what is matching my requirement.Can I have code for YTD.

means If I select a month APR ,sales of a particular product from JAN to APR.

Please help me for YTD.

Regards

Tripati

[arulsettu]

maybe try this

sum({<month={'>=$(=YearStart(date(max(month))))<=$(=max(month))'}>}sales)

[sunny_talwar]

Like this?

[tripatirao]

Dear Sunny

Thanks for reply

If I select Apr the value for Pen will be 280.

i.e. 100+50+30+100

Please check the excel for your reference and do the needful.

Regards

Tripati

[tripatirao]

Dear Sunny

Please help me to find the YTD.

Regards

Tripati

[sunny_talwar]

Your first Excel file showed a different output. May be try the attached: