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 Standard Edition One
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Dec 24, 2012 11:53 PM by
Remove additional rows from grand total in pivot
Nov 21, 2012 2:10 AM
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: Remove additional rows from grand total in pivot
Dec 24, 2012 11:53 PM
in response to
I think You need aggregate ( dts Assigned+Pending+WIP ).
to achive this click on measure column, set aggreaget as SUM.
Then add Total, which is shown on the upper side of the rows.
Second method is , you can create one more column like (Assigned+Pending+WIP) and add this as measure in the analysis.
Mark if correct,