Inserts create new records in reporting table

Love the forum,

I'm bringing 100k - 200k of AR transactions into a table from several
separate ERP companies.

As I insert the records, does it make sense to run a trigger event to
build or insert data into

a reporting table (to save generating a query to build the reporting
table later.)

For example, I bring in 120k records which contain invoice dates from
the beginning of time

in the ERP system. (eg; records with dated transactions from 2010...2022)

Conceptual data

[Location][InvoiceDate][Amount]

Dallas        2012-01-09    7500.00
Dallas        2012-11-19    1200.00
Dallas        2012-04-02    500.00
Phoenix       2012-01-03    1200.00
Phoenix        2012-04-12    7500.00

Would it be possible, or would it make sense to create a trigger which
populated another

table like below after each insert...or is is a resource killer..or just
unnecessary, and smarter to create a query

that performs calculated on the fly columns for the dates of invoice?

[Location][InvoiceDate][Amount]    [Jan]            [Feb]     [Mar]    
       [Apr]          [May]             [Jun]      [Jul]         [Aug]
          [Sep]            [Oct]     [Nov]         [Dec]

Dallas         2012-01-09                   7500.00

Dallas 2012-11-19 1200.00

Dallas 2012-04-02 500.00

Phoenix    2012-01-03                    1200.00

Phoenix 2012-04-12 7500.00

Bret