Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I have a date field in the format 'YYYY-MM-DD' 'TransDate' and a measure amount.
I wish to create a bar chart, with each bar representing the Sum(Amount) for the max date in each month. Note: Max date means not the month end date. It is the max date for which the data exists.
How can this be achieved?
Thanks
Sayali
as below
=sum(aggr(if(TransDate=Max(total <MonthYear> TransDate),Sales),MonthYear,TransDate))