Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Conditionally hide subtotal row

953124Sep 6 2012 — edited Sep 27 2012
I am creating a new analysis where I want to conditionally hide a subtotal row in a pivot table view. I have two columns - Is Consolidated and Property Name. Properties can be consolidated or not so I have Is Consolidated as an attribute (values True or False) and I add both to an pivot table view of an analysis. I made Is Consolidated so that it has subtotals after and then hide the Is Consolidated column so that the pivot table view looks like so:

Property A
Property B
Property C
True Total
Property D
Property E
False Total
Grand Total

However, I want the report to look like so (don't show the False Total line):

Property A
Property B
Property C
True Total
Property D
Property E
Grand Total

I found the following - http://gerardnico.com/wiki/dat/obiee/answer_xml but my situation is a little different and when I pull the equation out it never finds it so it doesn't ever apply the conditional formatting.

Is this possible?
Comments
Locked Post
New comments cannot be posted to this locked post.