Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
900
Totals not showing in pivot grid
posted

I have very basic case, where I have a collection of a custom object with a bunch of properties that I want to pivot:

public MyStuff
{

public string Row1 { get; set;}
public string Row2 { get; set;}
public string Col1 { get; set;}
public string Co2 { get; set;}
public int Metric1 { get; set;}
public int Metric2 { get; set;}

}

ObservableCollection MyStuff { get; set;}
FlatDataSource DataSource { get; set;}

Init()
{
     MyStuff = GetStuff();
     DataSource = new FlatDataSource();
     DataSource.ItemsSource = MyStuff;

}

   
                    MaxWidth="300"
            DockPanel.Dock="Left"
            DataSource="{Binding DataSource}" />
                    AllowCompactLayout="True"
            DataSource="{Binding DataSource}">
       
   

On the screen, I can drag/drop my objects properties from the data selector on the pivot grid, and everything is fine, EXCEPT, I don't see the totals rolls, and I can't collapse/expand.

In the examples provided, this seems to work fine without anything special.  Do I need to do anything special to have the totals rows/columns show up and be able to expand/collapse the hierarchies?

 

*Edited: Fixed typo in binding