Last 6 Months Data Trend in Bar Chart

nayanpatel — Tue, 21 Dec 2021 20:15:22 GMT

Hi Friends,

I need formula to get last 6 months data trend in Bar Chart

For Example

If user will select Feb 2020, The trend should show last 6 months data from Feb 2020 to Aug 2019

Now

Aug 2019 should be sum of (Feb 2019 to July 2019)

Sep 2019 Should be Sum of (March 2019 to Aug 2019) and so on

I have attached excel file which shows required output in numbers. But output must be in Bar Chart

Thank you

topic Last 6 Months Data Trend in Bar Chart in App Development