I have a reporting requirement to show the Sales Amount per month of current year and last year, as shown below (based on country).
Data is coming like this from the HANA view, and first 12 rows (Orange) are mapped for Last year sales and next 12 rows (green) are mapped for current year sales.
But, the issue is that all countries are not having data for all the 12 months, hence the chart will look wrong in that case as shown in the below example-
In the above example, there are no values for Jan to June, and hence the mapping will go wrong in the chart.
So, when the data from the hana view is coming only for valid months, is there any way to show the empty months also in the dashboard excel as shown below.
Thanks a lot