Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Sub total for all except percentage column

Hi,
I have requirement to build a pivot table where in all the metrics will have subtotals and totals except the percentage metric.
I tried the below two options. It didnot work .
- Percentage Metric -> Criteria - > Aggregation - None (Didnot work, the subtotals are coming up)
- Pivot Table -> Percentage Metric-> mouse icon, Aggregation- None(Didnot work. All the data disappeared)
Is there any other way to achieve subtotal and total for all metrics but not for the percentage columns?.
Thanks,
K
Answers
-
Subtotals are always calculated across all measures in a pivot (and in a table). Percentage is a measure so it will have a subtotal.
0 -
Hi K,
Did you try to move the percent column to rows?
Regards.
Edit: Additionally, in table view if you disable the aggregation (by setting it to None) the percent sub-group and group level totals are not displayed.
0 -
Hi Manoj,
Yes i did, it doesnot display any data.
Regards,
K
0 -
Not sure about your question then after seeing your above reply.
0 -
Do you want this or something else?
0 -
Hi Andrew,
Yes please. I wanted to display all the columns subtotals in a pivot except for the percentage column.
may i know which version of the obiee were you using?/ What did you do to achieve this.
Regards,
Kalpana
0 -
Hi Manoj,
One thing i forgot to mention is, i was doing top 10 and others report in pivot table. In this case, the data was disappearing when i selected aggregation none in the pivot table for the percentage metrics.
for the same report, i moved the percentage column to the rows section in the pivot table and have unchecked treat as attribute column for the percentage metric, but my client did not liked it to be placed there so i had to go for other options.
I finally completed this requirement by using Table view ,top 10 in one report and others in another report.
Thanks,
K
0 -
Hi Andrew,
I forgot to mention, i was working on top 10 and others report in the pivot table. In that case i was not able to remove the subtotal from the pivot table percentage column.
In normal pivot table, i was able to remove subtotal for the percentage metric by using aggregation none option for the percentage metric.
Thanks,
K
0