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

Hiding Sub Totals for Row Items

11 Answers 291 Views
PivotGrid
This is a migrated thread and some comments may be shown as answers.
Gerald
Top achievements
Rank 1
Gerald asked on 18 Sep 2012, 08:36 PM
Hey,

I have a couple of nested row items and I do not want to the show the totals for each group since they are meaningless to the client.

Desired Layout 
Person Name August
Product
Budget 15
Actual 14
Production 2
Budget 16
Actual 16

Is there a way to hide the Total footers that would show up under the Person Name field and the Product? This is being done with the latest version of the PivotGrid for ASP.NET AJAX

11 Answers, 1 is accepted

Sort by
0
Maria Ilieva
Telerik team
answered on 21 Sep 2012, 12:48 PM
Hi Gerald

In the current version of RadPivotGrid the required functionality is not implemented. However our developers are actively working on this feature and it would be available for the next official release of the controls which is planned for the second half of October.

Kind regards,
Maria Ilieva
the Telerik team
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 their blog feed now.
0
Oliver
Top achievements
Rank 1
answered on 14 Nov 2014, 02:25 PM
Has this functionality been implemented? We found that we needed the ability to hide certain row totals from our very first use of RadPivotGrid. I can't see it in the documentation.

If it has not been implemented, is it scheduled for a future release?
0
Maria Ilieva
Telerik team
answered on 20 Nov 2014, 11:16 AM
Hello Oliver,

Unfortunately the required feature is not implemented in the RadPivotGrid control. After deep research on this task our dev team came to a conclusion that this functionality could not be achieved with the core Pivot Engine we are building our control on and for now such functionality will not be added.

Excuse us for any inconvenience this limitation may lead.

Regards,
Maria Ilieva
Telerik
 

Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

 
0
Pradeep Deshpande
Top achievements
Rank 1
answered on 02 Jul 2015, 01:51 PM

Hi telerik Team, 

  How to change the Aggregate function for specific rows .I am using rowsubtotals and using aggregate as sum for aggregate columns.but want some row subtotals calculated as average instead of sum.Please find the attached screen shot will show oil price is summed up instead of average. 

 

For example : First 5 rows-subtotal have an aggregate as sum and the price rows need average aggregate.currently i am not able find any property or solution to calculate the average.please help any one have solution

below is aspx markup

<telerik:RadPivotGrid ID="RPG_Variance" AllowPaging="false" PageSize="10" Skin="Metro" Height="460px" RowGroupsDefaultExpanded="false" TotalsSettings-RowsSubTotalsPosition="First" RowTableLayout="Outline"
                           AccessibilitySettings-ColumnHeaderTableCaption="" TotalsSettings-ColumnGrandTotalsPosition="None" TotalsSettings-RowGrandTotalsPosition="None"
                           OnCellDataBound="RPG_Variance_CellDataBound" AllowFiltering="false" ShowFilterHeaderZone="false" OnNeedDataSource="RPG_Variance_NeedDataSource"
                           ShowDataHeaderZone="false" runat="server" ShowColumnHeaderZone="false">
                           <ClientSettings EnableFieldsDragDrop="false">
                               <Scrolling AllowVerticalScroll="true" ScrollHeight="460px" SaveScrollPosition="true"></Scrolling>
                           </ClientSettings>
                           <Fields>
                               <telerik:PivotGridRowField DataField="Category" CellStyle-Width="200px" SortOrder="None">
                               </telerik:PivotGridRowField>
                               <telerik:PivotGridRowField DataField="Budget" CellStyle-Width="200px" SortOrder="None" >
                               </telerik:PivotGridRowField>
                               <telerik:PivotGridColumnField DataField="MonthDate" CellStyle-Width="50px" SortOrder="None">
                               </telerik:PivotGridColumnField>
                               <telerik:PivotGridAggregateField DataField="Original" Aggregate="Sum" CellStyle-Width="90px" 
                                   DataFormatString="{0:N2}">
                                   
                               </telerik:PivotGridAggregateField>
                               <telerik:PivotGridAggregateField DataField="Scenario" Aggregate="Sum" CellStyle-Width="90px"
                                   DataFormatString="{0:N2}">
                                     
                               </telerik:PivotGridAggregateField>
                               <telerik:PivotGridAggregateField DataField="Variance" Aggregate="Sum" CellStyle-Width="90px"
                                   DataFormatString="{0:N2}">
                               </telerik:PivotGridAggregateField>
                               <telerik:PivotGridAggregateField DataField="Var" Aggregate="Sum" CellStyle-Width="90px"
                                   DataFormatString="{0:N2}%">
                               </telerik:PivotGridAggregateField>
                           </Fields>
                       </telerik:RadPivotGrid>

 

 

0
Maria Ilieva
Telerik team
answered on 07 Jul 2015, 08:55 AM
Hi Pradeep ,

I am afraid this is no a supported scenario. You can have different aggregate functions for the different aggregate fields but not for the different rows. 

Regards,
Maria Ilieva
Telerik
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
0
Robert
Top achievements
Rank 1
answered on 09 Jul 2015, 01:32 PM

This control is worthless.

 You guys need to stop touting this and many of the Grid features as 'Excel-like',,,because they ALWAYS fall short of the mark. Always. The filter feature is half-baked. The Gantt-control is half baked. This PivotGrid is half-baked. You guys always take your controls to the 75% mark and stop there.

0
Maria Ilieva
Telerik team
answered on 14 Jul 2015, 07:30 AM
Hi Robert,

 Thank you for your feedback.

We are doing our best to provide fully functional and features rich controls, however, in some cases not all expected by our client features are added into the control's design. In case we have requests from our customers for any specific functionality we are always open to discuss it with our development team and do the best to implement it if possible.
You can also use the feedback portal below for adding your feedback:
http://feedback.telerik.com/project/108

Regards,
Maria Ilieva
Telerik
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
0
Robert
Top achievements
Rank 1
answered on 20 Jul 2015, 12:58 PM
http://feedback.telerik.com/Error/HandleError?aspxerrorpath=/project/108
0
Maria Ilieva
Telerik team
answered on 20 Jul 2015, 03:35 PM
Hello Robert,

The presented link is leading to an error page. Can you please post the correct link for the feedback item you have logged?

Regards,
Maria Ilieva
Telerik
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
0
Samuel
Top achievements
Rank 1
answered on 08 Feb 2017, 10:54 AM

Dear Telerik,

Is there an "update" with the subtotals ?

Idea is to remove the subtotal as we can do under excel.

Regards

Sam

0
Eyup
Telerik team
answered on 13 Feb 2017, 06:52 AM
Hello Sam,

You can examine the properties provided in the following 2 tags:
<telerik:RadPivotGrid>
    <TotalsSettings RowsSubTotalsPosition="None" />
    <RowTotalCellStyle ForeColor="LightCoral" />
</telerik:RadPivotGrid>

Currently, there are no further plans the include any further functionality regarding the pivot total cells. You can create a feedback item if you want to add your own idea for a new feature:
http://feedback.telerik.com/project/108

Regards,
Eyup
Telerik by Progress
Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Tags
PivotGrid
Asked by
Gerald
Top achievements
Rank 1
Answers by
Maria Ilieva
Telerik team
Oliver
Top achievements
Rank 1
Pradeep Deshpande
Top achievements
Rank 1
Robert
Top achievements
Rank 1
Samuel
Top achievements
Rank 1
Eyup
Telerik team
Share this question
or