Pivot grid cells selectable feature together with events to retrieve the pivot grid data for the selected cell.

First of all, we are using the 'Telerik UI for ASP.NET Core' product. We would like to ask you about the PivotGrid component, since we are having a strange behavior with the application of filters on the dimensions once the PivotGrid shows the data.

The use case is as follows:

1. We configure the PivotGrid applying two dimensions, one in a column (‘family_name’) and the other in rows (‘bc_name’) and select a measure (‘Amount’), and the PivotGrid is generated as expected. (see Case1.png)
2. We apply one filter to the columns, for example ‘family_name’ contains ‘OJOS’, and the PivotGrid is refreshed showing only the data filtered as expected. (see Case2.png and Case3.png)
3. We apply another filter to the rows, for example ‘bc_name’ contains ‘Barrios’, and the PivotGrid is refreshed showing only the data filtered by that filter, but no for the combination of the filter of ‘family_name’ applied before. (see Case4.png and Case5.png)

As you can see, the behaviour is strange, because we we can’t see the data with the application of both filters in combination.

I also included the code where we build the PivotGrid, if that can help to see the problem. (see Code.txt)

Hope that you can help us, because that is a real inconvenient for us.

 Thanks in advance.

I would like to request adding the Sort method to the MVC wrappers for the Kendo UI PivotGrid.  This is a very important feature for me.  

Thank you for the consideration.