I want to display earliest invested amount based on type (stock,fd,mutual fund,etc) over a month and want to keep number as unique. invested amount number amount number type date 100 1 Stock 2/12/2020 50 10 Stock 7/5/2020 200 2 Stock 4/15/2020 300 3 Mutual Fund 3/13/2020 400 4 Fix deposit 3/14/2020 300 5 Mutual Fund 4/01/2020 200 6 Stock 4/15/5050 660 7 Mutual Fund 5/1/2020 1000 8 Fix deposit 5/10/2020 800 9 Mutual Fund 6/20/2020 I want the output as sum based on per month by asset_type. example: stock = 300 for feb month have tries timechart but no results found is displaying.
... View more