Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Thanks
Sibin
Hi,
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.
Regards
RL