Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
nayanpatel
Partner - Creator
Partner - Creator

Last 6 Months Data Trend in Bar Chart

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

Last6monthdata.png

 

 

Thank you

Labels (1)
  • SaaS

0 Replies