You need to sign in to do that
Don't have an account?

Is there a way to merge task and events into a single column for reporting purposes.
Our Task and Events share the same activity types so when we report on events and tasks we get duplicate columns. Anyway of merging to two colums together to get a lum sum number for each activity type.
1st Meeting |
---|
1st Meeting |
---|
Call |
---|
Call |
---|
Follow-Up Meeting |
---|
Follow-Up Meeting |
---|
Meeting |
---|
Meeting |
---|
Other |
---|
Other |
---|
Webex Demo |
---|
Webex Demo |
---|
sales rep1 |
7 |
0 |
5 |
0 |
21 |
0 |
7 |
0 |
1 |
0 |
5 |
0 |
47 |
sales rep 2 |
11 |
1 |
0 |
0 |
86 |
0 |
28 |
0 |
0 |
0 |
0 |
1 |
132 |
sales rep 3 | 23 | 16 | 2 | 0 |
0 |
11 |
1 |
1 |
0 |
3 |
8 |
2 |
67 |
sales rep 4 |
33 |
2 |
0 |
0 |
52 |
1 |
4 |
4 |
0 |
0 |
8 |
3 |
107 |