Hi,
I am trying to add a calculated member as follows, but nothing shows up in the pivot grid.
IHierarchy dateCalendar = this.pivotGrid.DataSource.Cube.Dimensions["Person"].Hierarchies["Person"]; ICalculatedItemViewModel traderDiffCalcItem = new CalculatedMemberViewModel( dateCalendar, "person1 - person0", "person1 - person0", "[Person].[Person].[Person].[person1] - [Person].[Person].[Person].[person0]", true); this.pivotGrid.DataSource.Rows.Add(traderDiffCalcItem);
Any idea where I am going wrong?
Thanks,
Phil
Hi phil,
calculated items were only implemented to work with XmlaDataSource.
You can read more about this feature in our documentation here: http://help.infragistics.com/doc/WPF?page=xamPivotGrid_Calculated_Measures.html
M.Yovchev
Hi Peter,
I gave it a try with "[Person].[Person].[person1] - [Person].[Person].[person0]" to no avail.
I am using a FlatDataSource. So, for the sake of this example at least, there is no server component.
Hello Phil,
I have been looking into your issue and what first comes to mind is that you might have too many Person hierarchies. Could you please try this like so:
"[Person].[Person].[person1] - [Person].[Person].[person0]"
If this is not the cause could you please provide us with a bit more information about your sample and the server you are using, so we can look into this further.
Looking forward to hearing from you.