🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all hot features!
Get Free Trial

Always display values's caption

Seekme asked on August 13, 2019

Hi, I would like to always display values’s caption even if I only have one displayed.
You can see here : http://jsfiddle.net/fuwxh6m2/1/ that I have two values and “Sum of [values]”.
If I remove one values : http://jsfiddle.net/fuwxh6m2/2/ I still want “Sum of [values]” being displayed.
Is it possible ?

3 answers

Vera Didenko Vera Didenko Flexmonster August 14, 2019

Thank you for writing to us.
We would like to explain why in Flexmonster, in this case, a single measure is not intended to be displayed separately:
When there is more than one measure and [Measures] are defined in rows, each “Sum of [value]” is displayed in a row below the corresponding field for better readability.
When there is only one measure, there is no need to show it separately. The “Sum of [value]” is shown in the same row as the corresponding field and as a result grid space is used in moderation.
This is how measures are organized and can be displayed on the grid in Flexmonster.
Please let us know how critical this feature (showing a measure separately) is for your Flexmonster evaluation.
You are welcome to contact us in case of further questions.
Best Regards,

Seekme August 19, 2019

Thanks for your reply,
I understand your point but how do I know which measure I chose without having to open the Fields box ?
If I export my second exemple (http://jsfiddle.net/fuwxh6m2/2/), there is no way to know which measure is displayed (or is it ? Let alone the “Total Sum of” line). 

Dmytro Zvazhii Dmytro Zvazhii Flexmonster August 20, 2019

Thank you for your feedback.
Yes, you are right. Currently, the only way to define what measure is shown when there is only one selected is to check the total cell. If not customized it shows Total [Aggregation] of [Value].
As an alternative solution, you can try our static Field List approach: https://jsfiddle.net/flexmonster/qmLuesxw/. That allows checking the measure at any time.
Please let us know if everything works fine for you.

Please login or Register to Submit Answer