I Need to get only maximum date of each month data that can be showed in trend chart ...
Could anyone help with this problem..
What is your chart dimension? Can you provide more information on your dimensions and expressions?
My chart dimension is Month.
May be this:
FirstSortedValue(Aggr(Sum(Sales), Date), -Aggr(Date, Date))
It is not working in YTD,QTD Concept. When i select some month, it displays only the selected month data.
can you help with this,'
Would you be able to share a sample with the expected ouput?
Retrieving data ...