Virtual table with columns based on conditions

I have an INVENTORY table with the following inventory data: ProductID; Inventory_Amount; Inventroy_Quantity; Inventory_Days_Old.   ProductID = Product code; Inventory_Amount = Inventory in $ for e...