I am using radpivotgrid for achieving a customized report that have
Row -> Customer Name (Retrieving from Data Source)
Main Column -> Carrier Name (Retrieving from Data Source)
2 Sub Columns under Main Column -> "Minimum" and "MarkUp" - These are headings of the column
2 Data Columns under it need to show the minimum and markup values, that retrieved from data source.
And this need to be exported to excel. (please see below attachments for further clarification). Please suggest me to solve this.
1) Customer Carrier Report.png--> this is the output I am getting with pivot rad grid
2) Expected OutPut.png --> This is what I need to achieve.
Row -> Customer Name (Retrieving from Data Source)
Main Column -> Carrier Name (Retrieving from Data Source)
2 Sub Columns under Main Column -> "Minimum" and "MarkUp" - These are headings of the column
2 Data Columns under it need to show the minimum and markup values, that retrieved from data source.
And this need to be exported to excel. (please see below attachments for further clarification). Please suggest me to solve this.
1) Customer Carrier Report.png--> this is the output I am getting with pivot rad grid
2) Expected OutPut.png --> This is what I need to achieve.