1 Reply Latest reply: Nov 22, 2012 1:39 AM by sayak RSS

    Grant Total in Pivot table OBIEE-Aditional column removal

    swastik007
      Hi All

      I need to have a report where i am adding a date value in the measure so that my first heading will be weekwise.

      Below is a sample of the result needed

      18-nov-2011
      Assigned | Pending | WIP |Grand Total
      p1|p2|p3 p1|p2|p3 p1|p2|p3 p1|p2|p3

      In column i am putting the date feild,then the priority,This grand total is a calculated column which i am adding in the measure.

      My requirement is that i do not want to show the individual priorities in the grand total.It should only show the sum of the values in Assigned,Pending,WIP.

      I am not able to achieve this.Can you please help in this regard.