function MassUpdateofFilters() {
    var spreadsheet = SpreadsheetApp.getActive();
    spreadsheet.getRange('Andrew!A1').activate();
    var sourceData = spreadsheet.getRange('Batches!1:997');
    var pivotTable = spreadsheet.getRange('A1').createPivotTable(sourceData);
    pivotTable.setValuesDisplayOrientation(SpreadsheetApp.Dimension.ROWS);
    var pivotValue = pivotTable.addPivotValue(3, SpreadsheetApp.PivotTableSummarizeFunction.SUM);
    var pivotGroup = pivotTable.addRowGroup(5);
    pivotGroup.showTotals(false)
        .sortDescending()
        .sortBy(pivotTable.getPivotValues()[0], []);
    pivotGroup = pivotTable.addRowGroup(4);
    pivotGroup.showTotals(false);
    var criteria = SpreadsheetApp.newFilterCriteria()
        .setVisibleValues(['Andrew'])
        .build();
    pivotTable.addFilter(5, criteria);
    criteria = SpreadsheetApp.newFilterCriteria()
        .setVisibleValues([ '1', '2', '3', '5', '6', '7'])
        .build();
    pivotTable.addFilter(16, criteria);
    criteria = SpreadsheetApp.newFilterCriteria()
        .setVisibleValues(['April'])
        .build();
    pivotTable.addFilter(15, criteria);
    criteria = SpreadsheetApp.newFilterCriteria()
        .setVisibleValues(['2019'])
        .build();
    pivotTable.addFilter(17, criteria);
};