Well today is my day to fight with a XamPivotGrid.

So I got my grid to reload data and the new data appears in the dropdown filter selectors but it does not appear in the pivot grid itself.  When I filter and select the new data only the pivot grid shows no items.  How do I fix this?  The code blow is called in the loaded event of the grid and when the user clicks the refresh button.

thank you,

Sam

private void ExposureGrid_Loaded(object sender, RoutedEventArgs e)
{
 ExposureGrid.Loaded -= ExposureGrid_Loaded;

 Refresh();
}

private void Refresh()

{
 var x = ViewModel.GetExposureItems();
 ExposureGrid.DataSource = (IOlapViewModel)FindResource("FlatData");

 if (ExposureGrid.DataSource.Filters.Count > 0)
  ExposureGrid.DataSource.Filters.Clear();

 FilterHelper = new XAMPivotFilterHelper<ExposureItem> { FlatDataSource = ((FlatDataSource)ExposureGrid.DataSource) };
 FilterHelper.FlatDataSource.ItemsSource = x;

 ExposureGrid.DataSource.Filters.Add(ExposureGrid.DataSource.CreateFilterViewModel(
 ExposureGrid.DataSource.Cube.Dimensions["PM_Name"].Hierarchies.First()));

 ExposureGrid.DataSource.Filters.Add(ExposureGrid.DataSource.CreateFilterViewModel(
  ExposureGrid.DataSource.Cube.Dimensions["DeliveryDate"].Hierarchies.First()));

 ExposureGrid.DataSource.Filters.Add(ExposureGrid.DataSource.CreateFilterViewModel(
  ExposureGrid.DataSource.Cube.Dimensions["IsFail"].Hierarchies.First()));

 FilterHelper.FilterOption("DeliveryDate", "All", false);
 FilterHelper.FilterOption("IsFail", "All", false);
 FilterHelper.FilterOption("IsFail", "N/A", true);
 OnDeliveryChanged(this, new EventArgs());
 OnPMFilterChanged(this, new EventArgs());
 chkIsNetFails_Click(this, new RoutedEventArgs());
 ExposureGrid.DataSource.ResultChanged += FilterHelper.OnResultChanged;
 ExposureGrid.DataSource.RefreshGrid();
}
}