Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
We have a product hierarchy Category -> Product Group -> Product (Using hierarchy function we are building this)
We have the sales detail at both Prodcut and Product Group level and forecast at Product Group level. And both metrics are displayed in a same chart.
If we choose any Product in the report, Forecast values will not be shown in the chart since it is at Product Group level.
Now the requirement is,
we need to show the forecast detail for the product groups under which the selected products are in.
Hi.
Transform your data model to use different keys for sales (products) and for forecasts (product groups).
Look for hierarchy statement at help and reference manual.