In OTN forums some body has raised this question http://forums.oracle.com/forums/thread.jspa?threadID=1009297&tstart=0 Joe has done a great job by using java script
Step1: Create a report in pivot table by giving a column in section
Step 2: If you want to make the Central Region,Western Region tables to be horizontal we need to add Java script code suggested by Joe.
---Code
http://docs.google.com/Doc?docid=0ARnxwgf7H8OzZGdoNnE1M2hfMTIyZ3pudHEyZjI&hl=en
Step3: Add this code to Static Text and don't forget to check Contains HTML Markup
Go to Compound Layout--->Add Pivot table and Static Text using Add view and save the report.Thanks joe for your post.......