Stimulsoft Business Intelligence System | Forum

Hi,

I have built a pivot table in a dashboard, but I cannot get the zero values displayed. Only values > 0 are displayed.
How can I get that?

Thanks

Hello,

Please send us a sample report with test data that reproduces the issue for analysis.

Thank you.

Hi Max,
Please find attached an example based on the excel file KPIsvalues.
As you can see, I want to display the values of KPI1 and KPI2 during months 1,2,3,4,5 and 6.
- KPI1: it has value = 0 in months 2 and 6, while there is no value for month 3
- KPI2: it has value = 0 in month 2, while the is no value for month 4

However, the pivot table makes no difference between 0 and NULL values. In both cases it shows a blank cell.

What I need is to show zeros insted of blank (blank should appear only if there is no value at all)

WHat should I do?

Hello,

We need some additional time to investigate the issue, we will let you know about the result.

Thank you.
#6771

Hi Max,
Do you have any news about this issue? Could you fix it?
Thanks

Hello,

We are still working on the issue, we will let you know about the result.

Thank you.

Hi Max,
Do you have any news about this issue?
Could you fix it?
Thanks

Hello,

We need some time to investigate and fix the issue. We will let you know about the result.

Thank you.

Hi Max, any news on this ticket?
It's really confusing not to show zero values.
Thanks

Hello,

Unfortunately, no. Sorry.

Thank you.