How to filter obiee analysis but subtotal values?

In the analysis, I need to show all sold items for some period totals of which are bigger that some value let's say 100. When I apply this to item price it filters out items that have less price than given limit. However they contain in that period and participate in forming subtotals.

For example:

Item    Price 
A       56 
B       102 
C       9 
D       247

Total   414

Here if I set filter price> 100 it would show only items B and D. What I want is to see all items that participate in making total of 414, that is I want to filter by totals. Is it possible in OBIEE??

Solution

You have to use Selection Steps which are applied after the execution of the query and hence do not cut off the data stream.

You would say "Keep Only Items having Price > 100".

Sherzodbek any reason why you post all your questions here rather than then Oracle forums?