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.
