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