If any one want to group Markets in a region and their sales.We can achieve this by using bin with out writing long CASE Statements.Here is the work around by using Paint rpd
Step1: Pull two columns region and sales which will give you the sales in each and every region.

Step2: Click on Fx section on the column Markets

Step3: Go to Bin Tab, click on Add Bin button next add values what ever the values you want to be a group


Step4:You will get the report Region wise and also it will automatically sum up of all the Market values under a Region

Step5: If you click on Markets in Region 'A' then you will get all the Regions in that market with their values(years Ago Dollars)
Step1: Pull two columns region and sales which will give you the sales in each and every region.

Step2: Click on Fx section on the column Markets

Step3: Go to Bin Tab, click on Add Bin button next add values what ever the values you want to be a group


Step4:You will get the report Region wise and also it will automatically sum up of all the Market values under a Region

Step5: If you click on Markets in Region 'A' then you will get all the Regions in that market with their values(years Ago Dollars)