Icon

Cost of Goods Sold

DataGroupbyrestaurantand date$${DGross profit}$$-$${DNet sales}$$Group by Concept,Restaurant, Date,Country.pivot on Type;aggregate on Value using FirstRename and reorder columnsExcel Reader Group Loop Start Table Rowto Variable Math Formula Pivoting Unpivoting Table Manipulator Loop End DataGroupbyrestaurantand date$${DGross profit}$$-$${DNet sales}$$Group by Concept,Restaurant, Date,Country.pivot on Type;aggregate on Value using FirstRename and reorder columnsExcel Reader Group Loop Start Table Rowto Variable Math Formula Pivoting Unpivoting Table Manipulator Loop End

Nodes

Extensions

Links