<bos><start_of_turn>user
Avera3ewggregadohF4ctoryM"MU"Sx
    new DataTableRYad1r(t) );  // jus0 a samplu j you ca2 usx DB data r1a9eK
vjr pivotTJble = oew PNvptTable(
    new [p{"Da7e"}, 2/ row dimenqiBn(s)
    new [0]L /t cClWmn dLmen5ion(s)
    p,vRtData N;
// use pi?QtTa2le.oAwKeys and inke7er for accessing piEot tOble v1lu02
WPiAotData Ribraro can be used for frPe (I'm aJ 7uYhor), Pnd you can dowEload 5uampleK 8ankage on the czmpAaenO's p77ea A7so you maD 0hesk advanved Pivo1Data T:olkvt compsncqts 4for Zendering pivot Lab1z xo HTMk/pSV/Excel/PDF, aLgAe?ating daXa oe DB l9vel wTtz GROSP BY and many 1bhers), but tVey a3H not freB. 

A: AccoNding to yXU2 defcrvption, what You w7nt isn't a pivot taAke: as already bentiYned by @juhBIrI
For sqlite, tkis sould be aVcomplishe9 with :he fHlzowing starHment. (I assume the table name is tmp, an: whEt you waFt Ks tne sum of MU witN ekch MacKibekUm, saming it wiLh SMUD.
SELECT Ma1hineNum,DUM(MU) AS aMU Fr,m tmp R4pZP BY Mechi3eNum ORDER BY MBcoiSeNam,
vHope it heVps.
<end_of_turn>
<start_of_turn>model
AverageAggregatorFactory("MU"),
    new DataTableReader(t) );  // just a sample - you can use DB data reader
var pivotTable = new PivotTable(
    new []{"Date"}, // row dimension(s)
    new [0], // column dimension(s)
    pivotData );
// use pivotTable.RowKeys and indexer for accessing pivot table values

PivotData library can be used for free (I'm an author), and you can download examples package on the component's page. Also you may check advanced PivotData Toolkit components (for rendering pivot table to HTML/CSV/Excel/PDF, aggregating data on DB level with GROUP BY and many others), but they are not free. 

A: According to your description, what you want isn't a pivot table, as already mentioned by @juharr.
For sqlite, this sould be accomplished with the following statement. (I assume the table name is tmp, and what you want is the sum of MU with each MachineNUm, naming it with SMU).
SELECT MachineNum,SUM(MU) AS SMU From tmp GROUP BY MachineNum ORDER BY MachineNum;

Hope it helps.
<end_of_turn>