Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Fill the form
Get Free Trial

Adding plain row at end of pivot

Answered
Ajit Yadav asked on December 21, 2020

Hello Team,
I want to append row to flexmonster pivot table and dont want to do grouping as rest of the data. 
e.g. Consider a row like grand total which does not have any grouping like rest of the data. So instead of grand total row, I want to provide my own values.
Please let me know, how can I do it? 

6 answers

Public
Milena Pechura Milena Pechura Flexmonster December 21, 2020

Hello, Ajit,
 
Thank you for posting to our forum.
 
We would like to suggest the following workaround: you can use customizeCell to change the values of the grand total row.
Our team has prepared an example for illustration: https://jsfiddle.net/flexmonster/v86q4fdx/. In the customizeCellFunction, we specified the new total value for the column with color.[red] unique name. Using this function as a reference, you are welcome to change every value in the grand total row.
 
Hope it helps!
Do not hesitate to contact us in case any other questions arise.
 
Best regards,
Milena

Public
Ajit Yadav December 22, 2020

Thank you Milena for your response. Let me try out this option.

Public
Ajit Yadav December 22, 2020

Hello Milena, I tried with customizeCell function. It is taking static values, but not dynamic values. Is there any way to assign dynamic values to cells here?

Public
Milena Pechura Milena Pechura Flexmonster December 23, 2020

Hi, Ajit,
 
Thank you for your question.
 
Could you please provide us with further details about the desired component behavior? What logic are you trying to implement with dynamic values?
This info will help us understand your case better and provide you with the most relevant solution.
 
Looking forward to hearing from you.
 
Kind regards,
Milena

Public
Milena Pechura Milena Pechura Flexmonster January 8, 2021

Hello, Ajit,
 
Hope you are doing well!
 
Our team was wondering whether you achieved the desired component behavior. 
Could you please let us know if you still need assistance with your question regarding dynamic values? If so, could you please provide us with details about the functionality you want to implement?
 
Looking forward to your response.
 
Best regards,
Milena

Public
Milena Pechura Milena Pechura Flexmonster 7 days ago

Hi, Ajit,
 
How are you?
 
We would like to kindly take an interest in whether you implemented the wanted logic with the customizeCell function.
Please let us know if everything works fine.
 
Kind regards,
Milena

Please login or Register to Submit Answer