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
Please do not double post. This violates rule #4, please see http://www.cognoise.com/index.php/topic,24030.0.html (http://www.cognoise.com/index.php/topic,24030.0.html).
Any replies should go to the original thread at http://www.cognoise.com/index.php/topic,30612.0/topicseen.html (http://www.cognoise.com/index.php/topic,30612.0/topicseen.html).