Hi together, I'm new to the QV. Could anybody help me with my question how to get a fixed bar for Budgeted figures and figures for the Last year in a chart together with the Actual figures, that could be changed based on the actual month?
The Budget together with Last year volumes are based on the whole year, but the actual figures will be shown monthly. The other problem is that I need to use two dimensions the Version (actual, forecast, budget, last year, projection) and than a different type of "Hartegrad".
according to the monthly actuals they will be already in the data sheet as cummulative values for each month, and the yearly budget should be always swhown as yearly value so dont't need to divide it by 12.
regarding the two dimensions I'd like to show it as an stacked bar chart.
here's an exemple of the chart:
- i need to have the "budget" and "Vorjahr" to be fixed an not to change when I'm changing the Month in the list box (there will be also a list box for the year), the other 3 Bars should depend on the month and year selection.
- the actual will be added each month as a cummulative value, the Projection and Forecast will be also updated for each month as a yearly value
- the picture is showing all values when only Year 2012 is selected, at the time I will checked one of the months for example January I will lost the date for "Budget" and "Vorjahr "
- the year and date fields in the source data are organized as follows (whole year values have no month in the month field):