I'm working with the pivot grid trying to have it show sub-groups that do not have a certain status as well as only showing two particular values "Pending" & "Granted"
Dataset:
Grid:
Filter:
I've tried playing around with the ShowGroupsWhenNoData property but that adds the sub groups to all of the groups, which I do not want (Pivot_Filtered_ShowGroupsWhenNoData.PNG)
Expected outcome: Pivot_Filtered_Expected.PNG (Attached)
Actual outcome: Pivot_Filtered.PNG (Attached)
To summarize
I'm trying to achieve the view in Pivot_Filtered_Expected.PNG which is only showing the "Pending" and "Granted" columns. I also want to display sub-groups that do not have one of those status (so their values would be 0 and 0 respectively).
The problems I'm having now is it either shows the values that I do not want (if I don't have a filter) or it includes the sub-groups in the wrong business group (ShowGroupsWhenNoData).
Any advice on accomplishing the view I'm looking for?
Dataset:
DataTable table =
new
DataTable();
table.Columns.Add(
"Product And Business Group"
);
table.Columns.Add(
"Platform Or SubGroup"
);
table.Columns.Add(
"Status"
);
table.Rows.Add(
"Core"
,
"Core Sub Group"
,
"Granted"
);
table.Rows.Add(
"Core"
,
"Core Sub Group"
,
"Pending"
);
table.Rows.Add(
"Core"
,
"Sub Group should be shown in Core"
,
"Some Other Value"
);
table.Rows.Add(
"Non-Core"
,
"Non-Core Sub Group"
,
"Granted"
);
table.Rows.Add(
"Non-Core"
,
"Non-Core Sub Group"
,
"Pending"
);
table.Rows.Add(
"Non-Core"
,
"Sub Group should be shown in Non-Core"
,
"zAnother value"
);
Grid:
<
telerik:RadPivotGrid
ID
=
"RadPivotGrid1"
PageSize
=
"20"
runat
=
"server"
AllowFiltering
=
"true"
TotalsSettings-GrandTotalsVisibility
=
"None"
RowHeaderZoneText
=
"Business Group"
DataSourceID
=
"ObjectDataSource1"
Skin
=
"Windows7"
EmptyValue
=
"0"
>
<
TotalsSettings
GrandTotalsVisibility
=
"RowsOnly"
ColumnsSubTotalsPosition
=
"Last"
RowsSubTotalsPosition
=
"Last"
/>
<
ConfigurationPanelSettings
/>
<
RowHeaderCellStyle
Width
=
"200px"
/>
<
Fields
>
<
telerik:PivotGridRowField
Caption
=
"Product And Business Group"
DataField
=
"Product And Business Group"
>
</
telerik:PivotGridRowField
>
<
telerik:PivotGridRowField
Caption
=
"Platform or sub-group"
DataField
=
"Platform Or SubGroup"
ShowGroupsWhenNoData
=
"false"
>
</
telerik:PivotGridRowField
>
<
telerik:PivotGridColumnField
Caption
=
"Status"
DataField
=
"Status"
UniqueName
=
"Status"
>
</
telerik:PivotGridColumnField
>
<
telerik:PivotGridAggregateField
Aggregate
=
"Count"
DataField
=
"Status"
DataFormatString
=
"{0:D0}"
UniqueName
=
"StatusCount"
>
<
TotalFormat
Axis
=
"Rows"
Level
=
"0"
SortOrder
=
"Ascending"
TotalFunction
=
"NoCalculation"
/>
</
telerik:PivotGridAggregateField
>
</
Fields
>
<
ClientSettings
>
<
Scrolling
AllowVerticalScroll
=
"false"
ScrollHeight
=
"600px"
/>
</
ClientSettings
>
</
telerik:RadPivotGrid
>
Filter:
RadPivotGrid1.SetFilterIncludes(
"Status"
,
new
string
[] {
"Pending"
,
"Granted"
},
true
);
I've tried playing around with the ShowGroupsWhenNoData property but that adds the sub groups to all of the groups, which I do not want (Pivot_Filtered_ShowGroupsWhenNoData.PNG)
Expected outcome: Pivot_Filtered_Expected.PNG (Attached)
Actual outcome: Pivot_Filtered.PNG (Attached)
To summarize
I'm trying to achieve the view in Pivot_Filtered_Expected.PNG which is only showing the "Pending" and "Granted" columns. I also want to display sub-groups that do not have one of those status (so their values would be 0 and 0 respectively).
The problems I'm having now is it either shows the values that I do not want (if I don't have a filter) or it includes the sub-groups in the wrong business group (ShowGroupsWhenNoData).
Any advice on accomplishing the view I'm looking for?