Icon

Calculated formula

Back torowsAsc store, prod,weekDeleting emptyrowsBy storeand productFilter firstseven rowsRow numberRow numberSwitch variableMore than 7 rows, topLess, bottomMaxMore than 7 rows, topLess, bottomSecond valueRemove extra colsBy storeand productDataUnpivot Sorter Row Filter Group Loop Start Row Filter Extract TableDimension Table Rowto Variable VariableExpressions IF Switch GroupBy End IF Row Filter Column Filter Loop End Table Creator Back torowsAsc store, prod,weekDeleting emptyrowsBy storeand productFilter firstseven rowsRow numberRow numberSwitch variableMore than 7 rows, topLess, bottomMaxMore than 7 rows, topLess, bottomSecond valueRemove extra colsBy storeand productDataUnpivot Sorter Row Filter Group Loop Start Row Filter Extract TableDimension Table Rowto Variable VariableExpressions IF Switch GroupBy End IF Row Filter Column Filter Loop End Table Creator

Nodes

Extensions

Links