save as test report and delete the first criteria and see what is the result. show me the first criteria and second criteria. all the columns and filters. especially what is the formula inside amount column.

Let us know the output and kindly mark helpful correct answers.

12.2.1.0.0

Values are getting passed in 12.2.

It could be an issue with your internal security. There is no reason i could find values are not passing while it is hidden. Try from a different environment and see.

why not change the name in Titles and labels?

Apply this formula in Filter and check if you will get the top 1% RANK(sum("SALES_AMOUNT" by ""CUSTOMER_CODE"))<"CUSTOMER_CODE" by 'None')*0.01 add four columns in criteria so that you can validate the value Column 1 RANK(sum("Sales_AMOUNT" by "CUSTOMER_CODE")) column 2 Customer_code column 3. For the total sales amount…

I will have to try it in my environment. Will keep you posted.

Cant you remove the column names in criteria itself? show us some images to understand the clear issue.

check your initialization blocks

Hello Mark, If pasting TNSNames.ora doesnt work for you , while importing keep the entire TNSEntry in the datasource name. Important : The code after = TEST= (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=10.0.0.1) (PORT=1521) ) (CONNECT_DATA= (SERVER=dedicated) (SERVICE_NAME=TESTDB) ) )

it could fail when the number of customers are less than 100. So it is not the correct solution

What if , you have less than 100 customers? say for example just 20 customers?How will u calculate top 1% customers? Top 1% will be less than 1 May not work. Will check in the system and will update.

Nopes.. The second report i had an aggregation for Code column. If i remove it will not have any records over 10000. Can you please check in your environment? isnt it working in your BI system?

It had 400 records..

It is aggregated value for Code level

OBIEE 12.2.1.0.0 in AIX 7.1.0.0 . But it works in 10g onwards.

@Christian Berg But it seems like working for me.. I am using the values from a fact. a) Criteria 1 b) Bin Code c)Results of criteria 1 Report 2 results