I have created bar chart having two dimension month and Territory, and One measure
#Rangesum(Above(Sum({<#CalendarYear=-{'$(=$(#vCurrYear))'}, @CalendarMonthName=>}[ACT@AR]),0,RowNo()))*#vcurrrate
but i need to add one more measure for "Open Order" to Bar chart but that is not possible in bar chart
sum({<#CalendarYear={'$(=$(#vCurrYear))'}>}[ACT@AR])*#vcurrrate
so i want to convert bar chart to combo chart where we can have one dimension and 15 measures.
Bar chart:
Can anyone help how to convert range sum expression for 6 territory?
Territory are Mexico/CAC, Northeast, Southeast, zAmericas Other, South America, West.