IBP Key Figure to sum across all Products

[willsuus]

How can you create a total forecast for a given time period over all products? What planning level would you use?

For example, I have three products, A, B and C, with fcst of 100, 200 and 300 for month X. I would like a key figure that shows me 600 for month X.

[willsuus]

Using helper key figures, I was able to get a grand total that could be used in other key figure calculations.

[piyush_parekh]

Hi Susan,

In Excel UI, you can use attribute totals functionality and in Web UI (analytics), don't select any attribute in group by field to see the aggregated data.

Any specific requirement to have dedicated totals key figure?

Regards,

Piyush

[willsuus]

Thank you for your response. I believe I did not give a good explanation of what I am trying to do.

We are trying to take a total forecast and proportion it across a given customer attribute based on past orders. So, I need the total orders for the past x months to use as the denominator and then the total by customer attribute over that x months to use as the numerator to get a proportion that can be used against future forecast totals to split the forecast by that customer attribute.