Hi Telerik,
I'm trying to achive something like in the PivotGrid_ExcelBase image. There you can see the years (2012, 2013) columns with both personen and bedrag columns underneath.
Currently I tried to achieve that with the following code:
This shows me a grid as depicted in the PivotGrid_Rendered image. The person and budget columns are also grouped, that's not what I want.
How can I configure this?
Can you tell me how to do so?
Best regards,
Francois
I'm trying to achive something like in the PivotGrid_ExcelBase image. There you can see the years (2012, 2013) columns with both personen and bedrag columns underneath.
Currently I tried to achieve that with the following code:
01.
<
Fields
>
02.
<
telerik:PivotGridRowField
DataField
=
"SoortIndicatie"
UniqueName
=
"SoortIndicatieColumn"
Caption
=
"Soort Indicatie"
>
03.
</
telerik:PivotGridRowField
>
04.
<
telerik:PivotGridRowField
DataField
=
"SoortVerzilverd"
UniqueName
=
"SoortVerzilverdColumn"
Caption
=
"Soort Verzilverd"
>
05.
</
telerik:PivotGridRowField
>
06.
07.
<
telerik:PivotGridColumnField
DataField
=
"Jaar"
UniqueName
=
"JaarColumn"
Caption
=
"Jaar"
>
08.
</
telerik:PivotGridColumnField
>
09.
<
telerik:PivotGridColumnField
DataField
=
"Personen"
UniqueName
=
"PersonenColumn"
Caption
=
"Personen"
>
10.
</
telerik:PivotGridColumnField
>
11.
<
telerik:PivotGridColumnField
DataField
=
"Bedrag"
UniqueName
=
"BedragColumn"
Caption
=
"Bedrag"
>
12.
</
telerik:PivotGridColumnField
>
13.
</
Fields
>
This shows me a grid as depicted in the PivotGrid_Rendered image. The person and budget columns are also grouped, that's not what I want.
How can I configure this?
Can you tell me how to do so?
Best regards,
Francois