Hi,
Hoping someone can help with this - which I think will be a simple fix that's not occurring to me as a newbie.
I have 3 seperate datasets consisting of:
1. Volumes for previous Fin. year (apr-17 - mar-18)
2. Forecast volumes for current fin year (apr-18 - mar-19)
3. Volumes for current fin year to doate (Currently April-18 only).
What I want is to add these values to a clustered column and line chart so that no.2 is listed as a line, with the other 2 as bars.
This is so as to compare current performance against expectations (forecast) and previous years performance.
The issues I'm having are as follows:
By creating a seperate date table in query editor I've managed to get the axis displaying the full range of 2 years (Apr-17 - Mar-19) but only the forecast item (2. above) is showing in the chart correctly.
Item 3. above is showing as one repeating value all acrosss year 18-19 rather than just assigned to April
Item 1. above is only appearing correctly if shown as either line or chart on it's own (wihtout 2 &/or 3) and if the matching Date dataset is applied.
I'm pretty sure this may have somethign to do with relations ships in the date-table buty would appreciate advise on the best method to achieve what I mentioned above.
Thanks in advance.
D
