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
Quote from: niahanth on 06 May 2016 09:05:07 AM
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.
i am asking can it be done or not
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.