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.

Dear Telerik Support Team,

We are currently using the Telerik framework extensively in one of our projects — including grids, controls, calendars, and other components. Our experience so far has been excellent, and our goal is to fully adopt Telerik across our entire solution.

The only component we have not yet been able to fully migrate is the PivotGrid. We are currently using the DevExpress PivotGrid, but we would like to switch to Kendo PivotGrid, as we consider it to be a very powerful and modern development tool within your ecosystem.

However, during the migration process, we noticed a visual behavior that is not exactly an inconsistency but something we would appreciate your guidance on:

When building a PivotGrid with Telerik (using Kendo().PivotGrid() and an AJAX DataSource, not XMLA), the row field names are displayed inside an additional column. This layout increases the overall width and creates unused blank space.
In contrast, DevExpress displays the row field names above the related data block as a header, which helps make better use of the available space (please see attached images telerik.png and devexpress.png for reference).

We would like to know if there is a recommended way, configuration, or possible workaround to achieve a similar layout in Telerik’s PivotGrid, or if such a feature is being considered in the product roadmap.

Another property is showTotals in order to don´t show totals.

Thank you in advance for your assistance. We look forward to your response.