Cognos Count by colA

[sanchoniathon]

Hi there,

WE have a list report with 5 columns:

ColA, ColB, ColC, ColD, ColE

- Grouped on ColA
- ColE = days_between ( [Order Created], [Package Created] ))

QUESTION :
- We now need to display on another report (same or different page) to count the "number of times" all equal "ColE" values appear for each ColA value.
- For example: We want to know how many times does the value 1 is displayed on the report for each ColA. How many times does the value 2 is displayed, etc up until value 4.

ColA, NbTimesValue1, NbTimesValue2, NbTimesValue3, NbTimesValue4


regards.

[BigChris]

count(distinct [ColB] for [ColA])