Hello Clever Click,

Thank you for posting in our Community!

I believe you will find the Pivot Grid Remote Operations topic in our official documentation very helpful. There you can find more information regarding how to feed the pivot grid with already aggregated data. Please keep in mind that as stated in this topic, it is essential for the data to match the configuration of the pivot grid. For the best results no additional fields should be included into the aggregated data and no fields from the provided data should be left undeclared as rows or columns. The IgxPivotGrid component builds its data based on the PivotConfiguration and it is expected for the configuration and aggregated data to match accordingly.

Please let me know if you need any further information.

Regards,
Viktor Kombov
Entry Level Software Developer
Infragistics, Inc.

I have tried with Pivot Grid Remote Operations. It looks good, but I have some questions. It would be easier if I show you my test. 

I have these data:

• export const DATA = [
•     { Product: 'Clothing', Seller: 'Stanley Brooker',   Value: '94.2652032683907' },
•     { Product: 'Clothing', Seller: 'Elisa Longbottom', Value: '70.798922689072285'},
•     { Product: 'Bikes', Seller: 'Lydia Burson', Value: '35.799331607203619' },
•     { Product: 'Accessories', Seller: 'David Haley', Value: '41.411331268684627' },
•     { Product: 'Components', Seller: 'John Smith', Value: '60.474313730594851' }
• ];

And the Pivot Grid looks good. You see two Buttons above the Grid, which filter the rows or columns.

To filter the row, it works fine by filtering the DATA itself. And It is good.

I have question how to filter the columns. It is possible to filter with the method "filter", like this. 

• this.pivotGridComponent.filter("Product", "Accessories", IgxStringFilteringOperand.instance().condition("contains"));

But I failed to figure out, how to filter multiple columns. The filter method seems to only accept one item. Do you have an idea? Many Thanks

Regards,

Clever Click

I have created a small sample demonstrating how to filter multiple columns by passing to the filter method FilteringExpressionsTree instead of IgxFilteringOperand:

  public onFiltering() {
    const productFilteringExpressionsTree = new FilteringExpressionsTree(
      FilteringLogic.Or,
      'Product'
    );
    const productExpressions = [
      {
        condition: IgxStringFilteringOperand.instance().condition('contains'),
        fieldName: 'Product',
        ignoreCase: true,
        searchVal: 'Accessories'
      },
      {
        condition: IgxStringFilteringOperand.instance().condition('contains'),
        fieldName: 'Product',
        ignoreCase: true,
        searchVal: 'Bikes'
      },
    ];
    productFilteringExpressionsTree.filteringOperands = productExpressions;

    this.grid.filter('Product', null, productFilteringExpressionsTree);
  }

Please test the sample on your side and let me know whether you find it helpful.

Looking forward to hearing from you.

Regards,
Viktor Kombov
Entry Level Software Developer
Infragistics, inc.