Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Business Intelligence Foundation
Business Intelligence Suite Enterprise Edition
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Nov 22, 2012 1:39 AM by
Grant Total in Pivot table OBIEE-Aditional column removal
Nov 21, 2012 10:24 PM
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.
This content has been marked as final.
Show 1 reply
Re: Grant Total in Pivot table OBIEE-Aditional column removal
Nov 22, 2012 1:39 AM
in response to
did u checked " Remove calculated item members from view" in edit calculated item ?