Filter by total

Question

Hi

I have a report showing only deals for product A over 50k so the report looks like this

Product A          2016

Cloud                55000

The minute I drill to the product so now I have product A and B

Product A             Product B      2016

Cloud                    Cloud 1        25000

Cloud 2        30000

Total                                        55000

Since the filter is only to show over 50000 the in scenario 2 this record will disappear unless I can filter by Total.

Any idea on how I can filter by total.

Joe Choueiri-Oracle · Answer

Thank you Christian

Joe Choueiri-Oracle · Answer

Thank you so much @Gianni Ceresa

[Deleted User] · Answer

Addition to Gianni: What you'd be actually with that is creating a level-based measure for your fact. Basically a "Billed Quantity at Brand level". Works similar in all respects to level-based measures like "Revenue Year Total" which always aggregates at year level and allows comparison of other attribute/fact combinations agianst a level-based measure like "How much Revenue per Region did we make - in percent - compared to the year total of all regions?"

OBIEE 10G/11G - Level-Based Measure Calculations [Gerardnico]