Completed
Polya
Created on: 08 Jun 2015 09:43
Category: PivotGrid
Type: Feature Request
2
PivotGrid: Add a way to display all distinct values in value\label filter dialog
The DistinctValuesLimit property is available in our R1 2018 Release.

Kalin
Posted on: 06 Dec 2017 08:20
Hi Paulo,

There is another item in the portal regarding the filter TextBox, please vote for it on the the following link:
https://feedback.telerik.com/Project/143/Feedback/Details/201209-pivotgrid-filtering-textbox-for-distinct-values

As for this feature request we have added DistinctValuesLimit property to the Adomd and Xmla providers. It is already live with the latest internal build - please give it a try.

Kalin
Paulo
Posted on: 05 Dec 2017 14:40
I would like the suggest add filter textbox similar the excel. When there are many options is more easy use the text to filter the values.
Attached Files:
Software
Posted on: 20 Nov 2017 15:12
the WPF control code that is being used limits to top 100:

SELECT {TOPCOUNT(AddCalculatedMembers({[Products].[SKU].Children}), 1000)} DIMENSION PROPERTIES PARENT_UNIQUE_NAME,HIERARCHY_UNIQUE_NAME ON COLUMNS FROM [Account Planning]

I have changed this in the source code to test, but getting the controls building was impossible.
Paulo
Posted on: 20 Nov 2017 15:01
There is a KB solution to same problem in ASP.NET Ajax, https://www.telerik.com/support/kb/aspnet-ajax/pivotgrid/details/filter-list-missing-values-with-large-amount-of-data