Grouping data in a bar chart using the max date of every month

[Sayalirandive906]

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

[vinieme12]

as below

=sum(aggr(if(TransDate=Max(total <MonthYear> TransDate),Sales),MonthYear,TransDate))