Hello Sathya,

Take your time.

Best regards,
Martin Pavlov
Infragistics, Inc.

I'm working on this. and will let you know shortly. Thanks!

Hello Sathya,

I'm sorry but I still don't understand what is your use case here.

Anyway I don't think you need the "c" variable in your code. I used in only to make a link between the cell and the actual data related to that cell. In your case you probably need the cell value itself, but I cannot tell, because I don't know what is your grid data source schema.

Hope this helps,
Martin Pavlov
Infragistics, Inc.

Martin, you are right. My scenarios is slightly different from your example. Please go through my plan and give me suggestion if anything is wrong.

My pivot and grid does not share the same datasource/schema, so my aim is to get pivot's dimension and correspondence dimension value of this cell. So I guess I can put dimension/dimensionValue pair into data-dimensions like this:

aggregator: function (items, cellMetadata) {

var rowDimensions= $("#pivotGrid").igPivotGrid("option", "dataSource").rowAxis();
var colDimensions= $("#pivotGrid").igPivotGrid("option", "dataSource").columnAxis();

//myDimensionSeperateByUnderscore  = Product_Date
var myDimensionSeperateByUnderscore = MyFancyFunction(rowDimensions,colDimensions);

arr["" + c] = items[0];

return "<span data-ix='" + c++ + " data-dimensions=  "+myDimensionSeperateByUnderscore +" '>" + unitSoldSum(items, cellMetadata) + "</span>";

}

Note: arr only store the first item.

And then in iggridcellclick event, I can get acitve dimensions of pivot grid, and perform a search operation, show result in grid.

$("#pivotGrid").on("iggridcellclick", function (evt, ui) {
cellValue = $(ui.cellElement).find("span").attr("data-ix");
var cellDimensions =  $(ui.cellElement).find("span").attr("data-dimensions");

var dimensions = MyFancyDimensionsSplitFunction(dimensions); // i get ['Product', 'Date']

for(var d in dimensions){

 alert(cellValue[d]); //show every dimension value

}

});

Hello Sathya,

I'm attaching a sample that demonstrates the approach described in my previous post. The sample contains igPivotGrid and igGrid. When you click on a data cell the igGrid is populated with the records that participate in the aggregated data.

Best regards,
Martin Pavlov
Infragistics, Inc.