Cumulative Total within SAC Model

[djk13]

Hello Experts,

I am looking to create a running total for every material in my model and then break those totals down into percentages per functional area per month. I would like this calculation to be stored in the model, as opposed to a story, if possible. I am currently using SAC to S/4 HANA cloud connection, import model - not live.

For example, I have material X and material Y. 15 of Material X were consumed in functional area 1 in Jan, and 10 were consumed in functional area 2, but only 5 of those in January. So, 75% vs 25% would be my expected split for Material X in Jan.

What is the easiest way to accomplish this?

Thank you!

[N1kh1l]

djkoenig

Please show a report from SAC showing the consumption numbers for both materials across FA. Can I assume both FA and Material are dimensions in your model?

Nikhil

[saurabh_sonawane]

Hi,

You can use grandtotal function and try to get 75% and 25% in the value,

While displaying display functional area in column and in row material X and month

it will show you 75% VS 25%

Thanks,

Saurabh

[N1kh1l]

% Grand Total will not work correctly when you have data for more than one month. It will add all months together when doing the contribution.

Nikhil