Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ..all
The below is the sample data set / format i have ..what is my expression like in straight table if i will to get my YTD and MTD SalesAmount ?
Invoice date SaleAmount
1/1/2021 4568
.
.
1/6/2021 1234
2/6/2021 4321
.
.
.
29/6/2021 8888
In Script add new :
Year(Invoice date) as Cal_Year
Month(Invoice date) as Cal_Month
YTD:
Sum({<Cal_Year={$(=Max(Cal_Year))},Cal_Month= {"<=$(=max( Cal_Month))"}>}SaleAmount
MTD:
Sum({<Cal_Month= {"=$(=max( Cal_Month))"}>}SaleAmount
Thanks Dinesm030. Figures are shown now ..but the YTD and MTD is the same ..i wonder where goes wrong ...hmmmm