1. Home
  2. Forum
  3. WPF
  4. Top 10 + Others Value Filter

Top 10 + Others Value Filter

Currently... the feature in pivotgridcontrol filters only top 10 items and hides the remaining (Usage : Multifunctionalsortfilter menu - valuefilters - top10filter)
Is it possible to group items other than top 10 into "others" column and show grand totals ?
If not,
Is it possible that grand totals column shows totals of all items even after top 10 filter is applied (not just the totals of 10 items but all)

1 Reply
TB Thirupathi Bala Krishnan Syncfusion Team January 24, 2018 12:17 PM UTC

Hi Chaitanya, 

Please find our responses as below, 

Query  
Response 
Is it possible to group items other than top 10 into "others" column and show grand totals ? 
We have checked your requirement  and the Top10 filters feature that allows you to display the top most items only in PivotGrid control with hiding the rest of the items. If you need to display the items by excluding or hiding the top most items, then you can achieve the same by selecting the “Bottom” option available in Top10 filter window. 

Please refer to the attached screenshot from the following location. 
Is it possible that grand totals column shows totals of all items even after top 10 filter is applied (not just the totals of 10 items but all) 
As per our default behavior, we have displayed the grand total values by calculating the total values of rows and columns which are currently visible in PivotGrid control. We have implemented the feature as per the implementation of MS Excel. 

Please find the demo from the following location: 


If the above information does not enough your actual requirements, could you please share the detailed information along with your working sample so that it would be helpful to provide the solution at the earliest. 

Regards, 
Thirupathi B. 
 


Loader.
Up arrow icon