Get Free Trial

how to add an additional measure

RAFAEL asked on February 11, 2019

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


3 answers

Dmytro Zvazhii Dmytro Zvazhii Flexmonster February 12, 2019

Hello Rafael,
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:
As you can see, there is a single Quantity column at the end.
Please let us know any more guidance from us.

RAFAEL February 12, 2019

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.
Thank you

Tanya Gryshko Tanya Gryshko Flexmonster February 14, 2019

Hello, Rafael,
Yes, currently those columns are also exported to Excel. Could you please let us know how critical is that for your evaluation process?

Please login or Register to Submit Answer