Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want to do YTD MTD QTD on Order Amount but all values coming same.
Thanks
Prashant
Any help?
If you remove the header names from your expression you will see the result from your formulas. OrderDate is not resolved.
The varable is not resolved ok.
Try this:
=sum({<OrderYear={$(=vMaxYear)},OrderDate={"<=$(=max(OrderDate))"}>} [Ordered Amount])
Hi
Have a look This one.
Thanks
Hi Sovan,
Is there another any another way for YTD MTD QTD....
Thanks
Prashant