List <double> GetSelectedPivotValues(PivotGridControl pivot) { List <double> result = new List <double>(); foreach (System.Drawing.Point selectedCell in pivot.MultiSelection.SelectedCells) { result.Add(Convert.ToDouble(pivot.GetCellValue(selectedCell.X, selectedCell.Y))); } return(result); }
public void UpdateData(PivotGridControl pivot) { Random rnd = new Random(); List <double> values = GetSelectedPivotValues(pivot); MinValue = values.Min(); MaxValue = values.Max(); AverageValue = values.Average(); CurrentValue = Convert.ToDouble(pivot.GetCellValue(pivot.FocusedCell.X, pivot.FocusedCell.Y)); TotalValue = values.Sum(); TargetValue = TotalValue * 1 + TotalValue * 0.3 * ((rnd.NextDouble())); }