Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.
QUESTION
In the green cells calculate Gross Profit ( i.e. , Sales - COGS ) using the restriction ( s ) as specified and without creating a helper column ,
Please work in Excel Table and show formulas to I can see how to do. Thanks
In the green cells calculate Gross Profit ( i.e. , Sales - COGS ) using the restriction ( s ) as specified and without creating a helper column , using Filters , or Pivot Tables .DELVEBE | GERG`No restriction :"4 / 25 / 2019ProductsRegion 3SalesRep 2Customer1614 , 046. 005 , 337.48Production only :"4 / 25 / 2019Product ?Region4Sales Rep 15Customer 7 2S2 , 504. 00S1 , 702 .72Products and Sales Rep 16 only :"4 / 25 / 2019Product ?Region 4Sales Rep 18Customer 7 1S1 , 505 . 00S842.804 / 25 / 2019ProductsRegion 4SalesRep 14Customer 88S4 , 232. 00S2 , 793. 124 / 25 / 2019ProductsRegion4SalesRep 3Customer65S5 , 947 . 00S3 , 389 .794 / 25 / 2019Product ]RegionsSalesRep6Customer 1DoS5, 721. 00S3 , 203. 76