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>
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 your help, the documentation was helpful.
I found my solution on http://es.infragistics.com/forums/t/47783.aspx
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 :)