1 Reply Latest reply on Dec 25, 2012 5:53 AM by fiaz0419

    Remove additional rows from grand total in pivot

      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

      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.