Hello everybody,
Sorry for my english, i am French.
I need your help:
I have a report in cognos, I want to calculate the number of quotation with filter : region, product code and offer commercial.
The goal is to keep the rows which have more 2 quotations.
Thanks you for your answers.
try to use count (... for ...) in report data item; or use
count(...) over(partition by region, product_code, ...) in building FM model;
Thanks you for your help, but i don't access to framework manager. :(
STEP 1
Create a simple report showing all the columns you require and a column for "number of quotations".
Run the report, make sure it works properly and the numbers are correct.
STEP 2
I the query subject add a filter to the Summary Filter section for "number of quotations > 2".
(NOTE - That's SUMMARY FILTERS, not Detail Filter)
(that's all assuming it's a relational model not a cube based report.)
Thanks you it's Ok with a summary filter