I am using proc report to generate a report in which i want totals on Product group level and sub totals on Sub Product group level.
My Dataset structure(SALES_STK_CAL ) is some what below
PRD_GRP_NAME PRD_SGRP_NAME DEPT_NAME THIS_WEEK_SALES
A XYZ pqr 1000
A ABC lmn 2000
B def 3000
In the above dataset if you notice i have product group which dont have sub prodgrp and when i am breaking on Product group and sub prod grp i am getting to total lines for Prod grp B and i want to suppress the subtotal line when that prod grp doesnt have any subprod grp.
Below is the sample code.