Is it possible to have 2 dimensions and 2 expressions in a combination chart? My dimensions are Month and Value Type (Actual, Budget, Previous Year). What I want to do it diplay two sets of data on the same chart (MTD Sales and YTD Sales). The MTD sales are to be displayed in bar form and YTD sales in line form.
Ideally what I am looking for is a chart that is spaced over by months where for each month there are 3 bars (corresponding to Value Types) and 3 lines. When I try to do this now, I get the 3 bars, but only 1 combined line. Is there a way I can split that line into 3?