1 Reply Latest reply: Aug 10, 2012 5:15 AM by At titude RSS

    Trend Chart Issue

    Sibin Jacob.C C

      Hi,

       

      I have a trend chart with dimension Region and week.

      My expression is sum(volume). In this chart I am geeting trend lines for each selected region.

       

      I need one more line for showing Nation wise volume.

       

       

      Is there any way to implement this option ?

       

      In my fact table is Physician level.

      column are Physician_Name,Volume, Week.

       

      In my dimension table columns are

      Nation, Region_ID,Physician_Name

       

      Values like this

       

      'Nation','RG01','Sathyan'

      'Nation','RG02','Madhu'

      "Nation','RG02','Naseer'

       

       

       

      Please give me your ideas....


      Regards,

      Sibin Jacob.C