Please check and provide the solution for below:
1)Dimension : Month
Measures : Actual Sales,
Forecasting Sales
I want to show month wise data for the all the measures till December followed by excluding the data of current month and December month data for the Budget and Forecasting measures for combo chart.
2) Which chart is best to show the Balance Sheet scenario
3)Is the set analysis can be used as dimension
4)what is the Mashup