Forum Discussion
Insert Forecast Quarterly Bar Graph
Assuming I can create a measure that forecasts quarterly sales, how can I put Q3 forecast to the right of Q3 here? My date table doesn't have a forecast column, do I put one in?
right now the segments are in axis (which stores), the legend is quarterofyear from date table, and values is a measure "net sales."
Would I have to create a new table somehow with Q3 Projected as a column and Q2 Projected... etc.?
Hi Anonymous
If you'd like to add the forecast value in the graph right next Q3, that means there're 4 lengends. you'll need add the forecast rows in quarter column, and generate the forecast values also.
1 Reply
Hi Anonymous
If you'd like to add the forecast value in the graph right next Q3, that means there're 4 lengends. you'll need add the forecast rows in quarter column, and generate the forecast values also.