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

Filtering reduction

3 Answers 39 Views
PivotGrid
This is a migrated thread and some comments may be shown as answers.
Robert
Top achievements
Rank 1
Robert asked on 05 Feb 2015, 11:39 AM
Hi,

Assuming that I have a RadPivotGrid which contains 3 filters, year, quarter and month.

If I filter the values to a specific year and then try and filter on a specific quarter, the values which appear in the list of available quarters are outside of the previously filtered range.

The Attached screenshot illustrates this. The list of available filter values should be smaller given that I've already filtered for values in the year 2012.

Thanks

3 Answers, 1 is accepted

Sort by
0
Maria Ilieva
Telerik team
answered on 10 Feb 2015, 11:16 AM
Hello Robert,

I tried to replicate the described issue on my end, but to no avail. Can you please test the online demo below and let me know if you are able to replicate the issue with it?

http://demos.telerik.com/aspnet-ajax/pivotgrid/examples/firstlook/defaultcs.aspx

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
Robert
Top achievements
Rank 1
answered on 10 Feb 2015, 11:54 AM
With the online demo:

Click on the ProductName filter and see the list of values available
Filter the Category to be just "Confections"
Filter by ProductName;

I'd expect the list to be shorter and only display the values in the Confections Category. It's possible to pick a value which displays zero items.
0
Maria Ilieva
Telerik team
answered on 13 Feb 2015, 09:14 AM
Hello Robert,

Yes, I tested the described case and you are correct that the filters are not related.

This, however, is the behavior by design and it could not be changed ion the RadPivotGrid control. The related filters can not be implement due to the filtering specifics of the Pivot Engine.

Excuse us for any inconvenience this behavior 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.

 
Tags
PivotGrid
Asked by
Robert
Top achievements
Rank 1
Answers by
Maria Ilieva
Telerik team
Robert
Top achievements
Rank 1
Share this question
or