How to Create a Report or Chart that Show "# of Cases" by Multiple Fields
Hi 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)
------------------------------
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)
------------------------------
