How to show zero values in pivot tables
How to show zero values in pivot tables
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
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
-
- Posts: 824
- Joined: Tue Sep 07, 2021 10:11 am
Re: How to show zero values in pivot tables
Hello,
Please send us a sample report with test data that reproduces the issue for analysis.
Thank you.
Please send us a sample report with test data that reproduces the issue for analysis.
Thank you.
Re: How to show zero values in pivot tables
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?
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 163 times
-
- Report.mrt
- (6.39 KiB) Downloaded 165 times
-
- NoZeros.PNG (9.03 KiB) Viewed 1446 times
-
- Posts: 824
- Joined: Tue Sep 07, 2021 10:11 am
Re: How to show zero values in pivot tables
Hello,
We need some additional time to investigate the issue, we will let you know about the result.
Thank you.
#6771
We need some additional time to investigate the issue, we will let you know about the result.
Thank you.
#6771
Re: How to show zero values in pivot tables
Hi Max,
Do you have any news about this issue? Could you fix it?
Thanks
Do you have any news about this issue? Could you fix it?
Thanks
-
- Posts: 824
- Joined: Tue Sep 07, 2021 10:11 am
Re: How to show zero values in pivot tables
Hello,
We are still working on the issue, we will let you know about the result.
Thank you.
We are still working on the issue, we will let you know about the result.
Thank you.
Re: How to show zero values in pivot tables
Hi Max,
Do you have any news about this issue?
Could you fix it?
Thanks
Do you have any news about this issue?
Could you fix it?
Thanks
-
- Posts: 824
- Joined: Tue Sep 07, 2021 10:11 am
Re: How to show zero values in pivot tables
Hello,
We need some time to investigate and fix the issue. We will let you know about the result.
Thank you.
We need some time to investigate and fix the issue. We will let you know about the result.
Thank you.
Re: How to show zero values in pivot tables
Hi Max, any news on this ticket?
It's really confusing not to show zero values.
Thanks
It's really confusing not to show zero values.
Thanks
-
- Posts: 6458
- Joined: Tue Mar 20, 2018 5:34 am
Re: How to show zero values in pivot tables
Hello,
Unfortunately, no. Sorry.
Thank you.
Unfortunately, no. Sorry.
Thank you.