memberProvider Function | Infragistics Forums

this my full code it a js file in this i am calling the a handler which in returns a json object

var pivotgrid = function () {

var crntIndex = null;
var r = 0;
var getDataSource = function () {
$.ajax({
type: "GET",
url: "../Handlers/ExcelPivotHandler.ashx",
async: false,
success: function (jason) {

var rows = [];
var columns = [];
for (var j in jason.Table[0]) {

if (j.substring(j.length - 1, j.length) === 'R')
rows.push(j);
if (j.substring(j.length - 1, j.length) === 'C')
columns.push(j);

}

var rowJason = [];
var columnJason = [];
var c = 0;

if (columns.length > 0) {

for (var i = 0; i < columns.length; i++) {
columnJason[i] = {
"name": "" + columns[i],
"caption": "" + columns[i],
"memberProvider": function (item) {
return item["" + columns[i - 1]];
}
}
}
}
if (rows.length > 0) {

for (var k = 0; k < rows.length; k++) {
rowJason[k] = {
"name": "" + rows[k],
"caption": "" + rows[k],
"memberProvider": function (item) {
/// for (var m = 0; m <= r; m++) {
return item["" + rows[k-1]];
// }
}

}

if (columnJason.length > 0 && rowJason.length > 0) {
var jsonArray = [
{
caption: "Columns", name: "Columns", hierarchies: [{
caption: "Columns", name: "Columns", levels: columnJason
}]
},
{
caption: "Rows", name: "Rows", hierarchies: [{
caption: "Rows", name: "Rows", levels: rowJason
}]
}
];
}
else if (columnJason.length > 0 && rowJason.length <= 0) {
var jsonArray = [
{
caption: "Columns", name: "Columns", hierarchies: [{
caption: "Columns", name: "Columns", levels: columnJason
}]
}];
}
else if (columnJason.length <= 0 && rowJason.length > 0) {
var jsonArray = [
{
caption: "Rows", name: "Rows", hierarchies: [{
caption: "Rows", name: "Rows", levels: rowJason
}]
}
];
}

// var jsonArray1 = JSON.parse(jasonString);
// jsonArray = $.parseJSON("'" + jasonString + "'");

var pivotDataSource = new $.ig.OlapFlatDataSource({
dataSource: jason.Table,
metadata: {
cube: {
name: "Sales",
caption: "Sales",
measuresDimension: {
caption: "Measures",
measures: [ //for each measure, name and aggregator are required
{

caption: "Weighted Count",
name: "Weighted Count", aggregator: $.ig.OlapUtilities.prototype.sumAggregator('Weighted Count')
// returns a function that will be used as sum aggregatro on the 'UnitsSold property' of the data objects

}]
},
dimensions: jsonArray

}
},
// Preload hiearhies for the rows, columns, filters and measures
rows: "[Rows].[Rows]",
columns: "[Columns].[Columns]",
measures: "[Measures].[Weighted Count]"
});

$("#pivotGrid").igPivotGrid("option", "dataSource", pivotDataSource);
$("#pivotGrid").igPivotGrid("updateGrid");

}
});

}

$("#pivotGrid").igPivotGrid({
gridOptions: {
alternateRowStyles: true,
caption: "Cast Adhoc Report",
defaultColumnWidth: 150,
enableHoverStyles: true
},

deferUpdate: true,
compactColumnHeaders: true,
height: "430px",
width: "725px"
// tupleMemberExpanding: function (evt, ui) {
// r++;
// ui.memberIndex;

// ui.tupleIndex;
// }
});
return {
getDataSource: getDataSource
// jsonArray: jsonArray
}
} ();

and this my json data