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
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.
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.
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