This discussion is archived
1 Reply Latest reply: Nov 21, 2012 11:39 PM by sayak RSS

Grant Total in Pivot table OBIEE-Aditional column removal

swastik007 Newbie
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points