Creating a trigger from sql view : I have two tables that are updated by one function(GLPOST AND GLPOSTO).

I have created a view(GLREP) from this two tables that transpose the rows of GLPOSTO into columns as this is how i want my data.

Now i want to create a trigger(OPTIONAL) on this view to insert to a new table(GLREPORTEXCEL) once the view collects the data from the various tables in the view format.

View GLREP

CREATE VIEW [dbo].[GLREP] AS (SELECT * FROM (SELECT  GLPOST.ACCTID,JRNLDATE, GLPOST.FISCALYR, GLPOST.FISCALPERD, GLPOST.SRCECURN, GLPOST.BATCHNBR, GLPOST.ENTRYNBR, GLPOST.JNLDTLDESC, 
GLPOST.JNLDTLREF, GLPOST.TRANSAMT, GLPOST.CONVRATE,GLPOST.SCURNAMT, GLPOSTO.OPTFIELD,GLPOST.CNTDETAIL,  CSOPTFD.VDESC 
FROM GLPOST left JOIN GLPOSTO ON GLPOST.ACCTID = GLPOSTO.ACCTID AND GLPOST.POSTINGSEQ = GLPOSTO.POSTINGSEQ and glpost.CNTDETAIL=glposto.CNTDETAIL left JOIN 
CSOPTFD ON GLPOSTO.OPTFIELD = CSOPTFD.OPTFIELD AND GLPOSTO.VALUE = CSOPTFD.VALUE  ) as source pivot  (MAX([VDESC]) FOR [OPTFIELD] IN (ADVANCE,MEDICAL,MILEAGE,MOTORVEHICLE,PROMOTION,STAFF)) AS PVT )

MY TRIGGER THAT IS NOT WORKING(OPTIONAL)

CREATE TRIGGER OPTIONAL
 ON  GLREP
for INSERT
AS
INSERT INTO GLREPORTEXCEL
        (ACCTID, TRANDATE, FISCALYR, FISCALPERD, SRCECURN, BATCHNBR, ENTRYNBR, JNLDTLDESC, JNLDTLREF, TRANSAMT, CONVRATE, SCURNAMT, CNTDETAIL, STAFF, ADVANCE, MEDICAL, MILEAGE,MOTORVEHICLE,PROMOTION)
    SELECT 
       ACCTID, JRNLDATE, FISCALYR, FISCALPERD, SRCECURN, BATCHNBR, ENTRYNBR, JNLDTLDESC, JNLDTLREF, TRANSAMT, CONVRATE, SCURNAMT, CNTDETAIL, STAFF, ADVANCE, MEDICAL, MILEAGE,MOTORVEHICLE,PROMOTION 
        FROM inserted


NEW TABLE THAT I WANT TO INSERT IS CALLED :GLREPORTEXCEL