Hi Riva,

the context of this is that each boq grid row will have a list of area types and each area type will have a list of areas associated with it. The way it works you can't just set a property for it like with discipline, drawing number etc. I did however figured out a way around this and updated my boqgridrow class to the following:

 

class AreaTypeValue {
  public areaType: string;
  public areaValue: string;

  constructor(areaType: string, areaValue: string) {
    this.areaType = areaType;
    this.areaValue = areaValue;
  }
}

export class BillsOfQuantitiesGridRow{
  public id: string;
  public drawingNumber: string;
  public drawingSheet: string;
  public drawingRevision: string;
  public discipline: string;
  public schedule: string;
  public r6Item: string;
  public r7Item: string;
  public unitSymbol: string;
  public material: string;
  public quantity: number;
  public labourCost: number;
  public materialCost: number;
  public totalCost: number;
  public manhours: number;
  public areaTypeValues: AreaTypeValue[];

  public factoredManhours: number;
  public CCR: number;

  constructor(boqItem: BOQItem,
    dmbList: DrawingMeasurementBatch[],
    areaList: Area[],
    areaTypeList: AreaType[]){

      this.id = boqItem.id;

      const dmb = dmbList.find(dmb => dmb.id === boqItem.drawingMeasurementBatchId);
      this.drawingNumber = boqItem.drawingNumber;
      this.drawingSheet = boqItem.drawingSheet;
      this.drawingRevision = boqItem.drawingRevision;
      this.discipline = boqItem.disciplineDisplay;
      this.schedule = boqItem.scheduleDisplay;
      this.r6Item = boqItem.r6ItemDisplay;
      this.r7Item = boqItem.r7ItemDisplay;
      this.unitSymbol = boqItem.unitSymbol;
      this.material = boqItem.materialDisplay;

      this.quantity = boqItem.quantity;
      this.labourCost = boqItem.labourCost;
      this.materialCost = boqItem.materialCost;
      this.totalCost = boqItem.totalCost;
      this.manhours = boqItem.manhours;

      this.factoredManhours = boqItem.factoredManhours;
      this.CCR = boqItem.ccr;

      const areas = areaList.filter(area => dmb.areaIds.includes(area.id));

      this.areaTypeValues = areaTypeList.map(areaType => {
        const area = areas.find(a => a.areaTypeId === areaType.id);
        return new AreaTypeValue(areaType.name, area ? `${area.code} - ${area.description}`  : '');
      });
  }
}

  private configurePivotGrid() {

    const areaTypeDimensions = this.areaTypeList.map(areaType => ({
      memberName: areaType.name,
      displayName: areaType.name,
      memberFunction: (record) => {
        const areaTypeValue = record.areaTypeValues.find(value => value.areaType === areaType.name);
        return areaTypeValue ? `${areaTypeValue.areaValue}` : '';
      },
      enabled: true
    }));

    this.pivotConfig = {
      pivotKeys: {
        aggregations: 'aggregations',
        records: 'records',
        children: 'children',
        level: 'level',
        columnDimensionSeparator: '*',
        rowDimensionSeparator: '*',
      },
      columns: [

      ],
      rows: [
        { memberName: 'discipline', displayName: 'Discipline', enabled: false},
        { memberName: 'schedule', displayName: 'Schedule', enabled: false}
      ],
      values: [
        {
          member: 'quantity',
          displayName: 'Quantity',
          aggregate: {
            aggregator: IgxPivotNumericAggregate.sum,
            key: 'sum',
            label: 'Sum'
          },
          enabled: true
        },
        {
          member: 'labourCost',
          displayName: 'Labour Cost',
          aggregate: {
            aggregator: IgxPivotNumericAggregate.sum,
            key: 'sum',
            label: 'Sum'
          },
          enabled: true
        },
        {
          member: 'materialCost',
          displayName: 'Material Cost',
          aggregate: {
            aggregator: IgxPivotNumericAggregate.sum,
            key: 'sum',
            label: 'Sum'
          },
          enabled: true
        },
        {
          member: 'totalCost',
          displayName: 'Total Cost',
          aggregate: {
            aggregator: IgxPivotNumericAggregate.sum,
            key: 'sum',
            label: 'Sum'
          },
          enabled: true
        },
        {
          member: 'manhours',
          displayName: 'Manhours',
          aggregate: {
            aggregator: IgxPivotNumericAggregate.sum,
            key: 'sum',
            label: 'Sum'
          },
          enabled: true
        },
        {
          member: 'factoredManhours',
          displayName: 'Factored Manhours',
          aggregate: {
            aggregator: IgxPivotNumericAggregate.sum,
            key: 'sum',
            label: 'Sum'
          },
          enabled: true,
        },
        {
          member: 'ccr',
          displayName: 'CCR',
          aggregate: {
            aggregator: IgxPivotNumericAggregate.sum,
            key: 'sum',
            label: 'Sum'
          },
          enabled: true,
        }
      ],

      filters: [
        {
          memberName: 'drawingNumber',
          displayName: 'Drawing Number',
          enabled: false,
        },
        ...areaTypeDimensions,
        { memberName: 'areaTypeValues', displayName: 'area Values', enabled: false},
        { memberName: 'drawingSheet', displayName: 'Drawing Sheet', enabled: false},
        { memberName: 'drawingRevision', displayName: 'Drawing Revision', enabled: false},
        { memberName: 'r6Item', displayName: 'R6 Item', enabled: false},
        { memberName: 'r7Item', displayName: 'R7 Item', enabled: false},
        { memberName: 'material', displayName: 'Material', enabled: false},
        { memberName: 'unitSymbol', displayName: 'Unit Symbol', enabled: false}
      ]
    };
  }

Hello Lewis,

I am glad that you found a solution and managed to achieve your requirements.

Thank you for using Infragistics components.

Regards,
Riva Ivanova
Software Developer