1 Reply Latest reply: Jul 26, 2012 3:18 AM by Rahul Lakhina RSS

    First row in a straight table

    Sibin Jacob.C C

      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

       

       

       

       

      screen_shot1.jpg

       

      Thanks

      Sibin

        • Re: First row in a straight table
          Rahul Lakhina

          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