daiwhyte
asked on
Change and existing report
Hi All,
Ive got the attached report which pulls totals of various suppliers so it outputs like this.
Supplier Name Total
Supplier No1 6
Supplier No2 17
Supplier No3 9
Supplier No4 4
Supplier No5 8
Supplier No6 7
Supplier No7 5
Now I want to add Previous 5 days (1 column for each day) to the right of and a grand total of all totals at the end so it would look like this
Supplier Name 1st 2nd 3rd 4th 5th Total
Supplier No1 6 3 5 3 4 21
Supplier No2 17 5 3 8 6 39
Supplier No3 9 5 4 7 7 32
Supplier No4 4 3 5 3 4 21
Supplier No5 8 8 9 3 3 31
What do I need to do with the report to achieve this?
Thank you
D
Leads-by-Source-Summary-v1.0.rpt
Ive got the attached report which pulls totals of various suppliers so it outputs like this.
Supplier Name Total
Supplier No1 6
Supplier No2 17
Supplier No3 9
Supplier No4 4
Supplier No5 8
Supplier No6 7
Supplier No7 5
Now I want to add Previous 5 days (1 column for each day) to the right of and a grand total of all totals at the end so it would look like this
Supplier Name 1st 2nd 3rd 4th 5th Total
Supplier No1 6 3 5 3 4 21
Supplier No2 17 5 3 8 6 39
Supplier No3 9 5 4 7 7 32
Supplier No4 4 3 5 3 4 21
Supplier No5 8 8 9 3 3 31
What do I need to do with the report to achieve this?
Thank you
D
Leads-by-Source-Summary-v1.0.rpt
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Still waiting on feedback on this - sorry for delay.
ASKER
Thank you.
ASKER
Will post a reply once I have heard back.
Thanks
D