I think You will appreciate that You can be helped in this case by an attached workbook only. Can you attach please?
The issue you are currently facing is because of the Last 12 Months filter you have on your sheet. This is restricting the data from 2017 to start from Aug and the totals for 2017 will be restricted to the same range of data.
If this filter is a necessity, then please elaborate on your overall task so that we can help suggest other ways of execution.
Hope this helps.
Thanks for the quick response, actually the requirement is to show last 12 months of data on the chart only, hence the 12 months filter.
But, for 2017 Total they want to see it include all the months. Any ideas how this piece can be achieved?