Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE DAILY_DATA(DEPT INT,CLASS int, "DATE" DATE,BOOK_ID INT, TRANSFER_RETAIL DECIMAL(5,2),TRANSFER_COST DECIMAL(5,2));
INSERT INTO DAILY_DATA 
SELECT 100, 1,to_date('2022-04-10','yyyy-mm-dd'),100,23.4,54 FROM dual UNION ALL
SELECT 100, 1,to_date('2022-04-10','yyyy-mm-dd'), 200, 0, 92 FROM dual
2 rows affected

CREATE VIEW TOTALLED AS
SELECT
  DEPT,
  CLASS,
  "DATE",
  BOOK_ID,
    CASE WHEN BOOK_ID = 100 THEN SUM(TRANSFER_RETAIL) OVER(partition BY "DATE")
      ELSE TRANSFER_RETAIL end TRANSFER_RETAIL,
    CASE WHEN BOOK_ID = 100 THEN SUM(TRANSFER_COST) OVER(partition BY "DATE") 
      ELSE TRANSFER_COST end TRANSFER_COST
from DAILY_DATA
SELECT * FROM TOTALLED;


DEPT
CLASS
DATE
BOOK_ID
TRANSFER_RETAIL
TRANSFER_COST


100
1
10-APR-22
200
0
92

100
1
10-APR-22
100
23.4
146