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.
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
0
Accepted
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).
Hope this helps.
Regards,
Rosen Vladimirov
Telerik
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
Hi Zack,
You can try the Group Filtering feature and see if it helps.
Regards,
Martin Ivanov
Progress Telerik
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.