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 Last6monthdata.png](https://community.qlik.com/t5/image/serverpage/image-id/29929iB55EE5C9B6C5D517/image-size/large?v=v2&px=999)
Thank you