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?
⋅ 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
⋅ December 22, 2020
Thank you Milena for your response. Let me try out this option.
⋅ 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?
⋅ 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
⋅ 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
⋅ January 21, 2021
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
