Selective subtotals

[Darran]

Hi,

 I want to be able to hide a subtotal for particular fields within the pivot.

 I know I can use RowSubTotalsPosition="None" against the RadPivotGrid but that hides all subtotals.

 For instance, if a user adds both Customer Account and Customer Name to the pivot grid then I want to be able to suppress the subtotal of Customer Account. However, there could be an outer group (e.g. sales representative) that would want a subtotal.

 Is this possible?

 Many thanks,

Darran

[Kalin]

Hello Darran,

I'm afraid that with the current implementation of the control is not possible to hide only specific subtotals - you would need to hide them all.

If you have any other questions or concerns, please let us know.

Regards,
Kalin
Telerik

[Darran]

Hi Kalin,

 I was afraid that was the case.

 However, is that it? This is pretty useful, standard behaviour. I can imagine it would take some re-engineering of the objects, but it's pretty fundamental to pivot functionality.

 Ideally this option should present itself via the existing dialogues on the PivotFieldList.

 What do you think?

Cheers,

Darran

[Kalin]

Hello Darran,

Thanks for your feedback. I have logged that in our feedback portal as feature request. This way you would be able to easily vote for it and track its status on the following link:
http://feedback.telerik.com/Project/143/Feedback/Details/160700-provide-a-way-to-show-hide-particular-subtotals-of-pivotgrid

If you have any other questions or concerns, let us know.

Regards,
Kalin
Telerik

[Stefania]

Hi

Any news about this functionality?

[Kalin]

Hello Stefania,

The item is not in our plans for upcoming release (R2 2018). Please follow the Feedback item in order to get notified when there is an update.

Meanwhile can you please explain the scenario you want to achieve (Which totals you need to hide?), all the available feedback will be considered once the feature is being implemented.

I'm looking forward to your reply.

Regards,
Kalin
Progress Telerik

[Stefania]

Please refer to your "Pivot grid Layout" demo
The aggregates fields are "Quantity" and "Net". By default the Pivot grid add the subtotal column for each field.
I would like to decide on which ones fields I want to show the subtotals. For example the Net field.

In my scenario I have pivot with 20 aggregations and 3 column groups.
When I enable subtotals, a lot of columns will be added and the pivot is unreadable. So I need to show subtotals only for a few columns...  

Excel allow you to enable subtotals on specified columns, and choose one or more operators (sum, count, ecc)  

[Kalin]

Hello Stefania,

Thanks for the feedback - it will be considered for the implementation of this feature.

If you have any other questions or concerns - please let us know.

Regards,
Kalin
Progress Telerik