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.
