When I double-click on a cell, I'd like to access the underlying row that was used for the calculation.
I'd like to loop through every column for that row, access the values to know which row was clicked.
Basically to help us build a drilldown report for that row.
How can this be achieved?
Hi
This feature will be available for flat data in 11.1 volume of pivot grid. For SSAS you should use actions to get this data
RegardsTodor
Is it supported or not.. I'm confused as I see two different answers..
Also don't know what SSAS is.
Please assist. Thanks
Hi,
I double checked with Todor and as he understands your question, you are looking for the underlying data that is represented by a pivotGrid’s cell.
Since a picture may be worth a thousand words, Tudor provided these images.
Assuming you had the underlying data as in this image:
And the pivot control would analyze the data and show it as in this image
Tudor understood that when the pivotgrid’s red cell valued as 66 (a sum from values in previous table) is selected, you want access to the underlying data row 1 through 7.
This feature is not currently supported but will be implemented in the 11.1 version, which is expected to be released in May.
I had understood that you wanted to access the cells, rows or columns that had been selected in the pivotGrid.
You also asked about SSAS, that would be SQL Server Analysis Services which delivers OLAP (online analytical processing) data and data mining functionality.
I hope I've cleared up any confusion.
Yes. That's exactly what we are looking for.... Any idea when this change will be available?
Is there an alternate/workaround that can be done until this change is released.
Thanks
We would be happy if we are able to atleast the following details,
For example, from the attached screenshot..
i) if the user double-clicked on the value "66", we should be able to get something like "Region = East"
ii) if the user double-clicked on "36". , we should be able to get something like "Region=East AND Gender=Boy"
iii) if the user double-clicked on "30". , we should be able to get something like "Region=East AND Gender=Girl"
Pls. suggest if there's a way to get these details from the current version...(on a cell double-click event)
About your first question the release date for 11.1 version is planed for first week of June.
About second question you can use code below
private void pivotGrid_CellDoubleClicked(object sender, PivotCellClickedEventArgs e) { int rowIndex = pivotGrid.DataRows.IndexOf(e.Cell.DataRow); ITuple tuple = pivotGrid.DataSource.Result.RowAxis.Tuples[rowIndex]; IMember memberRegion = tuple.Members[0]; IMember memberGender = tuple.Members[1]; }
This code works in case you have two hierarchies droped in rows. I mean the region is one hierarchy and gender is another one.