good day, I need your support, I would like to know if I can add an additional measure at the end, what I need is to make an additional calculation to the total and show it aside, I send a reference image
Thank you for your question.
The design of Flexmonster Pivot Table implies that the newly added measure will be calculated for each member of the column’s hierarchy. Therefore, when you add a new measure the component displays the calculations for each member from the column’s hierarchy.
Considering that, the best option for your case is to hide the unnecessary columns. That can be done by applying the 0 width to unnecessary columns in Flexmonster’s config.
Here is the jsfiddle example: https://jsfiddle.net/flexmonster/58f1spbg/.
As you can see, there is a single Quantity column at the end.
Please let us know any more guidance from us.
Thank you for your prompt response, however when you export to excel those columns are also exported and what I need besides hiding them, is that they do not exist in the excel report because it would cause confusion when performing an operation.
Yes, currently those columns are also exported to Excel. Could you please let us know how critical is that for your evaluation process?