Filter on fact query item not working

[WILLA]

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