Hiding Sub Totals for Row Items

[Gerald]

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

[Maria Ilieva]

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

[Oliver]

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?

[Maria Ilieva]

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

 

 

[Pradeep Deshpande]

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>

 

 

[Maria Ilieva]

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

[Robert]

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.

[Maria Ilieva]

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

[Robert]

http://feedback.telerik.com/Error/HandleError?aspxerrorpath=/project/108

[Maria Ilieva]

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

[Samuel]

Dear Telerik,

Is there an "update" with the subtotals ?

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

Regards

Sam

[Eyup]

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