I am trying to COMPUTE sums on various fields by BRAND by MANUFACTURER by ID without showing the detail of the individual products that make up the BRAND and MANUFACTURER group of products. POSITION table (containing the various COMPUTE fields)
builds into SHELF table which builds into SECTION table (contains ID), with required product data (i.e. BRAND and MANUFACTURER) pulled from the PRODUCT table. Code below pulls the correct COMPUTE values but shows all the individual product details.
I only want to show COMPUTE at the BRAND then MANUFACTURER then ID levels without the detail that makes of the totals.
Select APO.SECTIONID, ASE.NAME, APR.MANUFACTURER, APR.BRAND, APO.CAPACITY, APO.DISTMOVEMENT, APO.SALES, APO.PROFIT, APO.ROII, apo.INVENTORY, apo.INVENTORYATRETAIL
from APSECTION ASE inner join
APPRODUCT APR on ASE.SECTIONID = APR.SECTIONID inner join
APPOSITION APO on APR.SECTIONID = APO.SECTIONID and APR.UPC = APO.UPC inner j
View Complete Post