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)
Posts
