Okay, checked out the web examples and still having problems. I tried the DECODE(GROUPING(PERIOD_NAME4),1,'PERIOD_AMOUNT4',PERIOD_NAME4) AS PERIOD_NAME4, and the query returns PERIOD_NAME4 as the column header. It does have the amount in the column, so am closer. Here is my entire sql, any help is approciated.
I was just trying to change the report to PL/SQL and cannot find the option that is in my book. When viewing the Report Attributes, the columns are listed but there is no options for Headings Type. I am on 4.1.0.00.32.
I also am still unable to get sql to work in TOAD to return the column value as the column header, any assistance is appreciated greatly.