Count number quotation for quantity

[Virgin]

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.

[johnGQ]

try to use count (... for ...) in report data item; or use
count(...) over(partition by region, product_code, ...) in building FM model;

[Virgin]

Thanks you for your help, but i don't access to framework manager. :(

[Robl]

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.)

[Virgin]

Thanks you it's Ok with a summary filter