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

Remove the zero values from the data output in flexmonster where data is coming from cube.

Nagaraj Chatiri asked on November 18, 2019

Hello Team, 
How to hide zero’s in the attached screenshot, highlighted in black rectangular box. The data is coming from the cube. Please advise of the steps. 


1 answer

Illia Yatsyshyn Illia Yatsyshyn Flexmonster November 20, 2019

Hello, Nagaraj,
Thank you for your question.
If you want to hide cells containing 0 values altogether, we would like to report that such a feature is not implemented for SSAS data sources in the current version of Flexmonster.
If you desire only to hide the value but leave the cell displayed, we recommend using customizeCellFunction.
Change the text property of cell in the desired way.
The function should look like the following one for your case:

function customizeCellFunction(cell, data) {
if (data.value == 0) cell.text = "";

Learn more about customizeCellFunction by the link: https://www.flexmonster.com/api/customizecell/.

We hope it helps.


Please login or Register to Submit Answer