asked on August 30, 2022
Hi,
I would like to use the FlexMonster Pivot Table in my project where I need to provide the facility of creating the reports at runtime to the end user.
I was looking to generate the new field at runtime with the combination of two or more fields. Those fields could be numbers or string. If they are numbers then end user can perform the arithmetic operations on it and if they are string then end user can produce the combination of those fields or put some static value which will repeat for all the rows.
How can I achieve this goal ?
Please assist me regarding the above.
Thanks & Regards
Sunny Karwal
⋅ August 30, 2022
Hello,
Thank you for raising a ticket.
Flexmonster has functionality for achieving this goal only for numbers, called Calculated Values. New values can be created via UI and saved and restored within the report. To add them from UI, go to the Field List and then press the "Add calculated value" button or the calculator icon near the "Values" tab to open the calculated value editor. Alternatively, you can open the editor with the openCalculatedValueEditor API call. Calculated measures support arithmetic functions applied to one or two arguments and some logical operations (see the complete list).
You are welcome to see the example of a calculated value created by multiplying two already existing values: https://jsfiddle.net/flexmonster/xp50d0wn/.
Feel free to contact us if other questions arise.
Best Regards,
Maksym
⋅ September 13, 2022
Hi,
Hope you are doing well.
Our team is wondering if you had time to look at the Calculated Values feature.
Please let us know if this functionality works for you.
Best Regards,
Maksym
⋅ September 20, 2022
Hello,
We would highly appreciate it if you provided some feedback regarding the suggested solution with the Calculated Values feature.
Best Regards,
Maksym
