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.
Thanks
Nagaraj
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.
Regards,
Illia