1. Home
  2. Forum
  3. ASP.NET Core - EJ 2
  4. Is this possible - not grouped columns?

Is this possible - not grouped columns?

Hi

I have pivot table with data about stock quantity.

I need to include in PivotView few columns to show description data about materials on stock.

I attached two screens - one from PivotView and another from Excel, where i added two columns ("Nazwa" and "Jednostka").

Can i add two columns in PivotView, without groupping?


Attachment: Pivot_6bee5c31.zip

3 Replies 1 reply marked as answer
SS Saranya Sivan Syncfusion Team February 12, 2021 08:43 AM UTC

Hi Tomsaz, 
  
Kindly use calculated field option, to create an additional column in pivot table. Kindly refer the below UG and online demo for your reference.   
  
   
  
Meanwhile, we have prepared a sample for your reference. Please find the sample link below, 
  
  
In the screen-shot below you can see that the columns "Total" and "Difference" are additional columns. 
  
 
  
We hope the above sample meets your requirements. Please let us know if you have concern.  
   
Regards,  
Saranya Sivan. 
 


Marked as answer
TO Tomasz February 12, 2021 12:19 PM UTC

Thank you fo fast response. 

What if i want to get this column after "Country" column, and not repeated in each quarters?

Calculated field are great for some data manipulation, but i don't need this columns repeated in each data group. I need only one column, at beginning of table, regardless of how many pivot columns are displayed.



SS Saranya Sivan Syncfusion Team February 15, 2021 03:08 PM UTC

 
Thanks for contacting Syncfusion support. 
 
We regret you to let you know that we cannot achieve this requirement. Since it is not a valid behavior. Either you can add the value in column or row axis using “valueAxis” property. Meanwhile we have prepared a sample for your reference. Kindly check the below sample and documentation link. 
 
 
 
Please let us know if you have concern. 
 
Regards, 
Saranya. 
 


Loader.
Up arrow icon