Need Help in Worksheet

Hello All,

How can i make any of part or higher Item level not visible in Worksheet if there are no any  History or Forecast ?

For Eg: If Planners are selecting any Product-line  in the worksheet and if any item under that product-line doesn't have History or Forecast under that product line, that particular item mustn't appear in the Worksheet.

In the attachment Screenshot 2, you can see that for one of the product-line there are no History or Forecast, now that mustn't appear in worksheet.

Thanks,

Sharath Chander M