This is a migrated thread and some comments may be shown as answers.

Replace Empty Cells With Zeros

4 Answers 159 Views
PivotGrid
This is a migrated thread and some comments may be shown as answers.
Ahmad
Top achievements
Rank 1
Ahmad asked on 14 May 2014, 11:46 AM
Hello.
Is there any way to replace the empty cells from the PivotGrid with zeros?.
the attached picture is an example of my PivotGrid I want to replace those empty cells with zeros.
Please Help me.

4 Answers, 1 is accepted

Sort by
0
Accepted
Rosen Vladimirov
Telerik team
answered on 14 May 2014, 12:02 PM
Hello Ahmad,

RadPivotGrid has EmptyValueText which you can set to "0". You can also use ErrorValueText in order to set 0 if an error happened while calculating the cell (for example divide by zero).

<pivot:RadPivotGrid  x:Name="radPivotGrid" DataProvider="{StaticResource DataProvider}" EmptyValueText="0" ErrorValueText="0"/>

Hope this helps.

Regards,
Rosen Vladimirov
Telerik
 
Check out Telerik Analytics, the service which allows developers to discover app usage patterns, analyze user data, log exceptions, solve problems and profile application performance at run time. Watch the videos and start improving your app based on facts, not hunches.
 
0
Ahmad
Top achievements
Rank 1
answered on 14 May 2014, 06:07 PM
Thank you very much you saved my life.
0
Zack
Top achievements
Rank 1
Veteran
answered on 19 Mar 2019, 05:00 PM
Is there a way to do the opposite - to not show a zero for values that are null?   In our case, we set some values and not others and it ends up with half of the cells with zeros and the other half blank. Very jagged and confusing.
0
Martin Ivanov
Telerik team
answered on 22 Mar 2019, 01:10 PM
Hi Zack,

You can try the Group Filtering feature and see if it helps.

Regards,
Martin Ivanov
Progress Telerik
Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
Tags
PivotGrid
Asked by
Ahmad
Top achievements
Rank 1
Answers by
Rosen Vladimirov
Telerik team
Ahmad
Top achievements
Rank 1
Zack
Top achievements
Rank 1
Veteran
Martin Ivanov
Telerik team
Share this question
or