I am using Powerpivot and OLAP cube formulas. My problem is that I have a flat file table (summed already) that I want to insert the contents on the "outstanding enc" line on the table. The table is by month, category and department. Any ideas of what cube functions to use to insert the data from the flat file into the cube table without aggregation?

Flat file table:
Month Year Department Month to date Year to date Category
September 2014 21030000 0.00 18,241.00 Outstanding Enc
September 2014 31020000 1,500.00 1,500.00 Outstanding Enc
September 2014 32020000 0.00 0.00 Outstanding Enc
September 2014 34020000 0.00 20.00 Outstanding Enc
September 2014 38020000 0.00 0.00 Outstanding Enc
September 2014 38030000 0.00 303.00 Outstanding Enc
September 2014 41020000 0.00 0.00 Outstanding Enc
September 2015 43030000 200,000.00 611,716.00 Outstanding Enc
September 2015 43050000 25,400.00 25,400.00 Outstanding Enc
September 2015 43060000 0.00 760.00 Outstanding Enc
September 2015 43070000 -28,992.00 30,614.00 Outstanding Enc
Cube table
FY2015 FY2014
Department Category Month Ytd Month Ytd
0 0 0 0
Thanks in advance