Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 201
  • Last Modified:

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
0
daiwhyte
Asked:
daiwhyte
  • 3
1 Solution
 
mlmccCommented:
Have you tried a cross tab and changing the selection criteria

{CONTACT1.CREATEON} >= {?Run Date} - 5
AND
{CONTACT1.CREATEON} = {?Run Date}

Cross tab
COlumn - CreateOn - for each day
Row - Country
Cells - Count of Country

mlmcc
Leads-by-Source-Summary-rev1.rpt
0
 
daiwhyteAuthor Commented:
Ive implemented your suggestions and Im waiting for feedback from my line manager but it looks good apart from a bit of format which needs to be done.

Will post a reply once I have heard back.

Thanks
D
0
 
daiwhyteAuthor Commented:
Still waiting on feedback on this - sorry for delay.
0
 
daiwhyteAuthor Commented:
Thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now