Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
This doesn't match you exact output, but is this what you were looking to get?
Try :
expression:
Sum( {<Year=,Month= ,Week =,Day=, DataNum={">=$(=Num(YearStart(Today())))<=$(=Num(Today()))"}>} Sales)
Check aswell:
Previous YTQ, QTD, MTD and WTD
Regards,
Grzegorz
This doesn't match you exact output, but is this what you were looking to get?
Hi,
try below
sum(Sales)-sum(aggr(above(sum(Sales)),Product,date))
Regards,
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
maybe try this
sum({<month={'>=$(=YearStart(date(max(month))))<=$(=max(month))'}>}sales)
Like this?
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
Dear Sunny
Please help me to find the YTD.
Regards
Tripati
Your first Excel file showed a different output. May be try the attached: