Hi everyone,
On framewok manager I created a query item ( count ( distinct id) ) = 500 000 which corresponds for example to the number of sales in report studio I created a list to show the number of sales per year.
Example
-----------
count(distinct id) = 500 000
In report studio :
--------------------------
Year Sales
2015 100 000
2014 30 000
2013 370 000
Assuming i want to see only years more than 100 000 sales (i create filter => applying after aggregation)
By analyzing the SQL code returned by the query cognos. The query filter sales more than "count(distinct id) = 500 000".
results after applying filter
--------------------------------
Year Sales
2015 100 000
2014 30 000
2013 370 000