// set data source (populates Fields list) fp.DataSource = GetDataTable(); // prevent updates while building PivotEngine view fp.BeginUpdate(); // show countries in rows fp.RowFields.Add("Country"); // show categories and products in columns fp.ColumnFields.Add("Category"); fp.ColumnFields.Add("Product"); // show total sales in cells fp.ValueFields.Add("Sales"); // done defining the view fp.EndUpdate();