Dispalying count and maximum count for a day side by side in a Cognos report.

[niahanth]

Hi All,

I have a list report in which i need to display office name in first row. In 2nd row i need to display total count of records for that office. In 3rd row i need to display total count which is maximum for a certain day. In the 4th column i need to display the day when the count is maximum.

I am attaching the screenshot. I need to use single list for this report.

Its relational modelling.

Thanks

[MFGF]

Hi All,

I have a list report in which i need to display office name in first row. In 2nd row i need to display total count of records for that office. In 3rd row i need to display total count which is maximum for a certain day. In the 4th column i need to display the day when the count is maximum.

I am attaching the screenshot. I need to use single list for this report.

Its relational modelling.

Thanks

Ok - so what's the question? Are you asking if it can be done?

MF.

[niahanth]

i am asking can it be done or not

[CognoiseDan]

Select MAX records for counts in Column 2 (total documents received), which should be column max daily peak. then take date from receive_dt for daily peak. Thats what i get from looking at your layout. Hope i got what your were asking for.