Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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);
- };
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement