Hi,
I do want sub total rows but only with one level of grouping. If I turn off subtotal grouping I loose the one total I want to display. If i have Rows sub total position on I have extra row total fields I do not want. Is there anyway to control this? For example based on my screen shot I want to to display the InstName total for each section but Not the AUN, CIP, Program etc.
thanks
I do want sub total rows but only with one level of grouping. If I turn off subtotal grouping I loose the one total I want to display. If i have Rows sub total position on I have extra row total fields I do not want. Is there anyway to control this? For example based on my screen shot I want to to display the InstName total for each section but Not the AUN, CIP, Program etc.
thanks
1 Answer, 1 is accepted
0
Hello Kristel,
I noticed that the same question has been submitted by another account in a support ticket.
Unfortunately, there is no way to hide individual totals and show others without breaking the RadPivotGrid layout. In such case your best options is to leave all totals visible. You could optionally empty the cell text in the RadPivotGrid CellDataBound event by checking if the e.Cell.Text equals a total that you do not want visible and setting the e.Cell.Text as empty string.
Regards,
Daniel
Telerik
I noticed that the same question has been submitted by another account in a support ticket.
Unfortunately, there is no way to hide individual totals and show others without breaking the RadPivotGrid layout. In such case your best options is to leave all totals visible. You could optionally empty the cell text in the RadPivotGrid CellDataBound event by checking if the e.Cell.Text equals a total that you do not want visible and setting the e.Cell.Text as empty string.
Regards,
Daniel
Telerik
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to the blog feed now.