I have a physicianwise table.Dimiension is Physcian name.Expression in sum(volume)
But in this First row I need Nationwise volumn.
Second row I need regionwise volumn
Use Nation and Region as your dimensions too.
Then go to Presentation tab in properties and click on Nation and check show partial sum and then repeat the process by clicking of Region.
This will give you a pivot table that can be drilled down and will provide you a view you require.
Retrieving data ...