Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want to extract the latest date value of every month for previous 10 months in my bar chart.
For Eg.
Month Date Value
Dec 1 December 2021 36
Dec 2 December 2021 56
Dec 3 December 2021 798
Dec 31 December 2021 334
Jan 2 Jan 2022 231
Jan 3 Jan 2022 433
Jan 31 Jan 2022 5432
Feb 2 Feb 2022 1231
Feb 3 Feb 2022 1325
Feb 28 Feb 2022 6547
March 2 March 2022 1231
March 3 March 2022 1325
March 31 March 2022 2527
April 1 April 2022 34
April 2 April 2022 45
April 30 April 2022 50
May 1 May 2022 342
May 2 May 2022 242
May 3 May 2022 7224
May 25 May 2022 21342
In this i have to make a bar chart in which only the latest date value of every month is needed.
Could anyone let me know how to extract the latest date value of every month.
Thanks