Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
Considering that there is 1000 records which is four months data, from that I am trying to extract the max month from my date format(MM/DD/YYYY) to find sum(amount).
Date attribute name E_date(MM/DD/YYYY).
i tried using the Expression in many ways to get month sum,
1) Sum({$<Month([E_Date])={"$(=Month(Max(Date([E_Date],'MM/DD/YYYY'))))"}>}Amount)
2) Sum({$<Month(Date([E_Date],'MM/DD/YYYY'))={"$(=Month(Max(Date([E_Date],'MM/DD/YYYY'))))"}>}Amount)
3) Sum({$<Date([E_Date],'MM/DD/YYYY')={"$(=Month(Max(Date([E_Date],'MM/DD/YYYY'))))"}>}Amount)
4) Sum({$<Date(Month[E_Date],'MM/DD/YYYY'))={"$(=Month(Max(Date([E_Date],'MM/DD/YYYY'))))"}>}Amount)
Could you help me how to achieve it.
Thanks 🙂
I got a solution with the below expression
Sum({$<[E_date.autoCalendar.Month]={"$(=Month(Max(Date([E_date],'MM/DD/YYYY'))))"}>}Amount)
Thanks for helping me 🙂
Hi,
Take a table from chart, take dimension as date {Ex. Order Date} after that add another dimension in the table as =[Ship Date.autoCalendar.Month] it will show month of the particular date.
Thanks
Tushar
I got a solution with the below expression
Sum({$<[E_date.autoCalendar.Month]={"$(=Month(Max(Date([E_date],'MM/DD/YYYY'))))"}>}Amount)
Thanks for helping me 🙂