How to create a stacked bar/column chart in SAC story using live connection model?

Hi,

I have a live connection model with following data:

data.jpg

I want to achieve the following chart in SAC using this data. Here I want to show sum of MTD and YTD by Type. From data: Type = One timer and the value should be 3 as we have three records.

chart.jpg

In my understanding the simplest way to do this is, to add a MTD/YTD-Type calculated column in the the model itself and add another column for OneTimer. In SAC, I can then select the MTD/YTD-Type as dimension and OneTimer as measure.

I just want to know, is there any other option without changing the model itself.