DBT Metrics - Different calculation_method (aggregation) along time dimension

Does dbt support a metric like ending on hand (EOH) inventory metric?

Using a bike shop as an example, if we have 5 mountain bikes and 6 road bikes on Tuesday, and towards the end of the week, we had 3 mountain bikes and 4 road bikes, the EOH (ending on hand) inventory metric will be calculated as follows:

  1. “sum(# of bikes)” along the product dimension
  2. “last value” along the time dimension

Is there a way to define this metric? It didn’t seem like we could calculate this by just using calculation_method and time_grains.