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.......
