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.
<olap:FlatDataConnectionSettings x:Key="FlatDataConnectionSettings" ItemsSource="{Binding colResourceHeadCountList}" />
<olap:FlatDataSource
x:Key="flatDataSource"
DimensionsGenerationMode="Metadata" Rows="[Division].[Division]" Columns="[Vendor].[Vendor]" Measures="Count"
ConnectionSettings="{StaticResource FlatDataConnectionSettings}">
<olap:FlatDataSource.CubesSettings >
<olap:CubeMetadata DataTypeFullName="ClientRepository.Service.SP_PIVOTResult" DisplayName="Data" >
<olap:CubeMetadata.DimensionSettings >
<olap:DimensionMetadata SourcePropertyName="Vendor" DisplayName="Vendor" DimensionType="Dimension" >
<olap:DimensionMetadata.HierarchyDescriptors>
<olap:HierarchyDescriptor SourcePropertyName="Vendor">
<olap:HierarchyDescriptor.LevelDescriptors>
<olap:HierarchyLevelDescriptor LevelName="Vendor" LevelExpressionPath="Vendor"/>
</olap:HierarchyDescriptor.LevelDescriptors>
</olap:HierarchyDescriptor>
</olap:DimensionMetadata.HierarchyDescriptors>
</olap:DimensionMetadata>
<olap:DimensionMetadata SourcePropertyName="Req_No" DisplayName="Req No" DimensionType="Dimension" >
<olap:HierarchyDescriptor SourcePropertyName="Req_No">
<olap:HierarchyLevelDescriptor LevelName="Req No" LevelExpressionPath="Req_No"/>
<olap:DimensionMetadata SourcePropertyName="Type" DisplayName="Type" >
<olap:HierarchyDescriptor SourcePropertyName="Type">
<olap:HierarchyLevelDescriptor LevelName="Type" LevelExpressionPath= "Type"/>
<olap:DimensionMetadata SourcePropertyName="Tracking_Id" DisplayName="Tracking Id" DimensionType="Measure">
<olap:HierarchyDescriptor SourcePropertyName="Tracking_Id">
<olap:HierarchyLevelDescriptor LevelName="Role Tracking Id" LevelExpressionPath="Tracking_Id"/>
<olap:DimensionMetadata SourcePropertyName="First_Name" DisplayName="First Name" >
<olap:HierarchyDescriptor SourcePropertyName="First_Name">
<olap:HierarchyLevelDescriptor LevelName="First Name" LevelExpressionPath="First_Name"/>
<olap:DimensionMetadata SourcePropertyName="Last_Name" DisplayName="Last Name" >
<olap:HierarchyDescriptor SourcePropertyName="Last_Name">
<olap:HierarchyLevelDescriptor LevelName="Last Name" LevelExpressionPath="Last_Name"/>
<olap:DimensionMetadata SourcePropertyName="Id" DisplayName="Id" >
<olap:HierarchyDescriptor SourcePropertyName="Id">
<olap:HierarchyLevelDescriptor LevelName="Id" LevelExpressionPath="Id"/>
<olap:DimensionMetadata SourcePropertyName="Center" DisplayName="Center" >
<olap:HierarchyDescriptor SourcePropertyName="Center">
<olap:HierarchyLevelDescriptor LevelName="Center" LevelExpressionPath="Center"/>
<olap:DimensionMetadata SourcePropertyName="Code" DisplayName="Code" >
<olap:HierarchyDescriptor SourcePropertyName="Code">
<olap:HierarchyLevelDescriptor LevelName="Code" LevelExpressionPath="Code"/>
<olap:DimensionMetadata SourcePropertyName="Team_Name" DisplayName="Team Name" >
<olap:HierarchyDescriptor SourcePropertyName="Team_Name">
<olap:HierarchyLevelDescriptor LevelName="Team Name" LevelExpressionPath="Team_Name"/>
<olap:DimensionMetadata SourcePropertyName="Domain1" DisplayName="Domain1" >
<olap:HierarchyDescriptor SourcePropertyName="Domain1">
<olap:HierarchyLevelDescriptor LevelName="Domain1" LevelExpressionPath="Domain"/>
<olap:DimensionMetadata SourcePropertyName="Domain" DisplayName=" Domain" DimensionType="Dimension" >
<olap:HierarchyDescriptor SourcePropertyName="Domain">
<olap:HierarchyLevelDescriptor LevelName="Domain" LevelExpressionPath="Domain"/>
<olap:DimensionMetadata SourcePropertyName="Division" DisplayName=" Division" >
<olap:HierarchyDescriptor SourcePropertyName="Division">
<olap:HierarchyLevelDescriptor LevelName="Division" LevelExpressionPath="Division"/>
<olap:DimensionMetadata SourcePropertyName="Product_Line" DisplayName="Product Line" >
<olap:HierarchyDescriptor SourcePropertyName="Product_Line">
<olap:HierarchyLevelDescriptor LevelName="Product Line" LevelExpressionPath="Product_Line"/>
<olap:DimensionMetadata SourcePropertyName="Deployment_Id" DisplayName="Deployment Id" >
<olap:HierarchyDescriptor SourcePropertyName="Deployment_Id">
<olap:HierarchyLevelDescriptor LevelName="Deployment Id" LevelExpressionPath=" Deployment_Id"/>
<olap:DimensionMetadata SourcePropertyName="Location" DisplayName="Location" >
<olap:HierarchyDescriptor SourcePropertyName="Location">
<olap:HierarchyLevelDescriptor LevelName="Location" LevelExpressionPath="Location"/>
<olap:DimensionMetadata SourcePropertyName=" Count" DisplayName=" Count" DimensionType="Measure" >
<olap:HierarchyDescriptor SourcePropertyName="Count">
<olap:HierarchyLevelDescriptor LevelName="Count" LevelExpressionPath=" Count"/>
</olap:CubeMetadata.DimensionSettings>
</olap:CubeMetadata>
</olap:FlatDataSource.CubesSettings>
</olap:FlatDataSource>
Hi Maria,
Thank you for your help, the documentation was helpful.
I found my solution on http://es.infragistics.com/forums/t/47783.aspx
Hello Ritika,
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.
I need the Same pivot grid to be expanded at load time itself. Please 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.
Thank You for the help :)