SELECT DISTINCT "date",
                Sum("daily_sales_y")               "DAILY_SALES_Y",
                Sum("daily_sales_lyy")             DAILY_SALES_LYY,
                Sum("daily_sales_m")               DAILY_SALES_M,
                "businessdt_month",
                "businessdt_year",
                COALESCE("portfolio_role", ' SBU') "PORTFOLIO_ROLE",
                "prod_name",
                Sum("daily_sales_lym")             "DAILY_SALES_LYM",,
"reportfilter"
FROM   "c1"
GROUP  BY "date",
          "businessdt_month",
          "businessdt_year",
          "reportfilter",
          rollup( "prod_name", "portfolio_role" )