我的总和金额发货的位置。有3个总的位置。今天我只得到一个位置的结果，因为有$0为其他两个。我想显示这些位置与$0。图片显示的位置与发货，我想它显示其他两个下面或上面与$0。包括代码的剪辑

SELECT [Facility_Table].facility 'Facility', isnull(sum(exten),0) 'Shipped'
FROM dtorder

下面是DDL/DML的一些示例

DECLARE @Locations TABLE (LocationID BIGINT IDENTITY, LocationName NVARCHAR(50))
DECLARE @Shipments TABLE (ShipmentID BIGINT IDENTITY, LocationID BIGINT, ShipmentAmount DECIMAL(10,4))

INSERT INTO @Locations (LocationName) VALUES
('Main Warehouse'),('New York Warehouse'),('Los Angeles Warehouse')

INSERT INTO @Shipments (LocationID, ShipmentAmount)
SELECT TOP 50 ROUND(((2 - 1) * Rnd1 + 1), 0), ROUND(((500 - 1) * Rnd1 + 1), 4)
  FROM (
        VALUES(
               RAND(CONVERT(VARBINARY,NEWID(),1)),
               RAND(CONVERT(VARBINARY,NEWID(),1))
              )
       ) a(Rnd1,Rnd2)
  CROSS APPLY sys.sysobjects