1. Home
  2. Forum
  3. Blazor
  4. Clarification in Pivot Grid

Clarification in Pivot Grid

I have an Pivot Grid  control in blazor web apps.I would like to know below points to accomplish my task.

1.How to change Subtotal and Grand total background color

2.How to change Data cell color in data area.

3.How to customize "Show Total/Hide Total" in Context menu (Show or Hide subtotal via context menu "

4. How to add Field in runtime ( Row Area,Filter Area, Data Area,Column Area).

5.How to customize "Sumnary Item" in Context menu (change summary item via context menu).

6.How to display Field List ( Should display all field with allotted area).

7.How to perform Drill down Data source and displayed in Grid control.

8.How to show Grand total in first column of Data Area


3 Replies 1 reply marked as answer
SS Saranya Sivan Syncfusion Team April 28, 2021 01:01 PM UTC

 
Hi Ismail, 
  
Please find the response below,   
   
Query  
Response  
How to change Subtotal and Grand total background color 
The appearance of HTML elements of the pivot table like header cell, value cell and summary cell can be customized using built-in CSS selectors. Please find the UG for your reference. 
  
  
Meanwhile we have prepared a sample which is available in the below link, 
  
How to change Data cell color in data area. 
How to customize "Show Total/Hide Total" in Context menu (Show or Hide subtotal via context menu " 
Based on your requirement we have prepared a sample. Please find the sample in below for your reference, 
  
  
How to add Field in runtime ( Row Area, Filter Area, Data Area, Column Area). 
We would like to inform you that your requirement can be achieved by using Field List option of pivot table. Please find the UG and demo link for your reference. 
  
Note: Field list allows you to add or remove fields and also rearrange them between different axes, including column, row, value, and filter along with sort and filter options dynamically at runtime. 
  
  
  
How to customize "Summary Item" in Context menu (change summary item via context menu). 
We suspect that your requirement is to change the aggregation type of the field using context menu. Using field list you can change the aggregation type. Please refer the below UG for more details, 
  
  
  
How to display Field List ( Should display all field with allotted area). 
Kindly refer the below UG and demo link, 
  
  
  
Meanwhile we have prepared a sample for your reference which is available in the below link, 
  
  
How to perform Drill down Data source and displayed in Grid control. 
Please refer our UG and demo sample to achieve your requirement. 
  
  
How to show Grand total in first column of Data Area 
We have already logged your requirement – “Provision to display the grand totals as first” as a feature task and it will be available in any one of our upcoming releases. You can track the same by using the following link:   
  
  
We appreciate your patience until then. 
  
Please let us know if you have concerns. 
  
Regards, 
Saranya S.  
 


Marked as answer
KI KINS April 28, 2021 01:21 PM UTC

Excellent support..

Thanks..

Syncfusion is great!!!!@

SS Saranya Sivan Syncfusion Team April 29, 2021 04:43 AM UTC

Hi Ismail, 
  
Thanks for the reply. 
  
Please let us know if you have any other queries. We are always happy to assist you.  
  
Regards, 
  
Saranya S. 
 


Loader.
Up arrow icon