Hi,
I am using xamPivotGrid. The scenario is that the cubeMetaData and dimensionMetaData are all defined for the Pivot I am using. DataTypeFulName and rows and columns are also fixed.
The Grid doesnt show All Total ans SubTotals. How can I achieve this?
Pardon me if this is a very basic question.
Hello Ritika and thank you for posting!
Would you please let me know what the type of data you are using is? By default the total rows and columns are displayed in the grid unless their IsVisible property is set to false. You may refer to the following forum threads for additional information about the totals in XamPivotGrid: http://es.infragistics.com/community/forums/t/71959.aspx http://es.infragistics.com/community/forums/t/67635.aspx Please feel free to let me know if I have misunderstood you or if you have any other questions regarding the same.
Hello Ritika,
Thank you for providing the code snippet. I have been looking into it and I noticed that you are adding only one level to each hierarchy descriptor. In order to display totals to each level you should add a HierarchyLevelDescriptor for them: http://help.infragistics.com/Help/Doc/WPF/2014.1/CLR4.0/html/xamPivotGrid_US_Defining_Hierarchies_And_Providing_Metadata_With_FlatData.html. Here is an example:<olap:HierarchyDescriptor SourcePropertyName="Vendor"> <olap:HierarchyDescriptor.LevelDescriptors> <olap:HierarchyLevelDescriptor LevelName="All verdors" /> <olap:HierarchyLevelDescriptor LevelName="Vendor" LevelExpressionPath="Vendor"/> </olap:HierarchyDescriptor.LevelDescriptors> </olap:HierarchyDescriptor>I am also sharing the links again for additional details on handling with the totals:http://es.infragistics.com/community/forums/t/71959.aspx http://es.infragistics.com/community/forums/t/67635.aspx If you need additional assistance on the same, feel free to update the thread
Hi Maria,
Thank You for the help :)
Thank you for your feedback Ritika. I am glad that the issue is resolved and I believe that this forum thread could be useful for other community members too.
I need the Same pivot grid to be expanded at load time itself. Please help!
I believe that the following page in our documentation will be helpful for you: http://help.infragistics.com/Help/Doc/WPF/2014.1/CLR4.0/html/xamPivotGrid_US_Expanding_Hierarchies_In_Runtime_From_Code.html. It describes two approaches that could be used to expand the hierarchies and it seems that the second one will be helpful for you.
Thank you for your help, the documentation was helpful.
I found my solution on http://es.infragistics.com/forums/t/47783.aspx