mrmmickle1
Well-known Member
- Joined
- May 11, 2012
- Messages
- 2,461
I have data that I have put into a Report.
The Group and Sort Setup I have looks like this:
Group on Date Received > Newest to Oldest
Group On Data Entry Tech
Sort By Num Of ACCN > Largest To Smallest > This doesn't seem to work Num of ACCN is a Calculated Field which comes from two Number Fields
The Report Look Like This Now:
I would like for it to look like this:
Is there an easy way to accomplish this? It doesn't seem to work when I use the Sort. Any help would be appreciated.
The Group and Sort Setup I have looks like this:
Group on Date Received > Newest to Oldest
Group On Data Entry Tech
Sort By Num Of ACCN > Largest To Smallest > This doesn't seem to work Num of ACCN is a Calculated Field which comes from two Number Fields
The Report Look Like This Now:
Excel 2012 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | May Daily Totals | |||||
2 | Date Received | Wednesday, May 20,2015 | ||||
3 | ||||||
4 | Data Entry Technician | ACCN Total | ||||
5 | Tiffany | 5 | ||||
6 | Mike | 55 | ||||
7 | John | 15 | ||||
8 | TOTAL | 75 | ||||
9 | Date Received | Wednesday, May 19,2015 | ||||
10 | ||||||
11 | Data Entry Technician | ACCN Total | ||||
12 | Tiffany | 5 | ||||
13 | Mike | 100 | ||||
14 | John | 15 | ||||
15 | Andrew | 300 | ||||
16 | Lanette | 25 | ||||
17 | TOTAL | 445 | ||||
Sheet1 |
I would like for it to look like this:
Excel 2012 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | May Daily Totals | |||||
2 | Date Received | Wednesday, May 20,2015 | ||||
3 | ||||||
4 | Data Entry Technician | ACCN Total | ||||
5 | Mike | 55 | ||||
6 | John | 15 | ||||
7 | Tiffany | 5 | ||||
8 | TOTAL | 75 | ||||
9 | Date Received | Wednesday, May 19,2015 | ||||
10 | ||||||
11 | Data Entry Technician | ACCN Total | ||||
12 | Andrew | 300 | ||||
13 | Mike | 100 | ||||
14 | Lanette | 25 | ||||
15 | John | 15 | ||||
16 | Tiffany | 5 | ||||
17 | TOTAL | 445 | ||||
Sheet1 |
Is there an easy way to accomplish this? It doesn't seem to work when I use the Sort. Any help would be appreciated.