ContributionsMost RecentMost LikesSolutionsRe: How to Create a Report or Chart that Show "# of Cases" by Multiple FieldsThank you for the help Mark! ------------------------------ Yifeng Gu ------------------------------ Re: How to Create a Report or Chart that Show "# of Cases" by Multiple FieldsHi Mark - Thank you for the quick response! I am confused about the second part of your solution - "Make a summary report". What I need is: the first column should be Date, and the second column should be "total worked cases on that date". for example, if I have a record that has three dates, in other words, been worked on three different dates, let's say 1/1/2020, 1/15/2020, and 1/31/2020. Then this record should be counted three times, separately. ------------------------------ Yifeng Gu ------------------------------ How to Create a Report or Chart that Show "# of Cases" by Multiple FieldsHi my name is Ethan. To be short, each "record" has 3 "Date" fields (let's say "Date 1", "Date 2", and "Date 3"), and I want to find a way to include all 3 Dates and show "# of records" by date (either a chart or a table will work). Please see the below picture: Now I have to create 3 summary reports and export them to excel above (column "Date 1","Date 2", and "Date 3") to add them up. All I need is either a Table/Chart/Summary to show the last column "Total".The problem is that QB can only count each record once, however, in my case, each record may be counted up to 3 times. Any thoughts will be greatly appreciated! ------------------------------ Ethan (Yifeng Gu) ------------------------------