How to show zero values in pivot tables

Stimulsoft Reports.WEB discussion
jlorue
Posts: 126
Joined: Thu Apr 15, 2021 6:33 pm

How to show zero values in pivot tables

Post by jlorue »

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
Max Shamanov
Posts: 768
Joined: Tue Sep 07, 2021 10:11 am

Re: How to show zero values in pivot tables

Post by Max Shamanov »

Hello,

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

Thank you.
jlorue
Posts: 126
Joined: Thu Apr 15, 2021 6:33 pm

Re: How to show zero values in pivot tables

Post by jlorue »

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?
Attachments
KPIsvalues.xlsx
(9.48 KiB) Downloaded 119 times
Report.mrt
(6.39 KiB) Downloaded 118 times
NoZeros.PNG
NoZeros.PNG (9.03 KiB) Viewed 1093 times
Max Shamanov
Posts: 768
Joined: Tue Sep 07, 2021 10:11 am

Re: How to show zero values in pivot tables

Post by Max Shamanov »

Hello,

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

Thank you.
#6771
jlorue
Posts: 126
Joined: Thu Apr 15, 2021 6:33 pm

Re: How to show zero values in pivot tables

Post by jlorue »

Hi Max,
Do you have any news about this issue? Could you fix it?
Thanks
Max Shamanov
Posts: 768
Joined: Tue Sep 07, 2021 10:11 am

Re: How to show zero values in pivot tables

Post by Max Shamanov »

Hello,

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

Thank you.
jlorue
Posts: 126
Joined: Thu Apr 15, 2021 6:33 pm

Re: How to show zero values in pivot tables

Post by jlorue »

Hi Max,
Do you have any news about this issue?
Could you fix it?
Thanks
Max Shamanov
Posts: 768
Joined: Tue Sep 07, 2021 10:11 am

Re: How to show zero values in pivot tables

Post by Max Shamanov »

Hello,

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

Thank you.
jlorue
Posts: 126
Joined: Thu Apr 15, 2021 6:33 pm

Re: How to show zero values in pivot tables

Post by jlorue »

Hi Max, any news on this ticket?
It's really confusing not to show zero values.
Thanks
Lech Kulikowski
Posts: 6198
Joined: Tue Mar 20, 2018 5:34 am

Re: How to show zero values in pivot tables

Post by Lech Kulikowski »

Hello,

Unfortunately, no. Sorry.

Thank you.
Post Reply