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

Aggregation based on string of row

Matheus Menezes asked on November 29, 2019

Hello! I’m trying the free edition of this plugin and i’m loving it! I just need to know some things about the aggregation feature…
What i want is: To sum NOT ALL of my aggregation values. But filter them into the calculation itself (and, at the same time, showing them on my grid). See my attachment for example…
Explaining my context: I have a grid of applications. And one of my application’s attributes is the status.
if, the status of the application is ‘Pago’ (paid in portuguese lol), it will be included in the calculation of the column of Lucro Líquido. So Lucro Líquido is the sum of all paid applications. And, still showing other applications values on the column at the same time, regardless of their status…
I tried to search this on the docs, but i could only find conditions based on number values, not different strings values or other types of conditions… Can you guys help me on this?

Thanks in advance, this library is great!


1 answer

Illia Yatsyshyn Illia Yatsyshyn Flexmonster November 29, 2019

Hello, Matheus,
Thank you for reaching out to us.
The described feature is not implemented in the current version of Flexmonster.
Our team would like to kindly suggest you using multiple dashboards with appropriate filtering in order to achieve the desired result.
Also, as a workaround, the text property of the cell containing grand total can be replaced with the appropriate value using customizeCell API. More information about cell customization can be found by the link: https://www.flexmonster.com/api/customizecell/.
We hope it helps.
Feel free to contact us in case of additional questions.
Kind Regards,

Please login or Register to Submit Answer