Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Previous Period Chart

Previous Period Chart

Previous Period Chart

I've created a summary report that totals sales per month by sales person. The bottom two charts in my example shows John Public's results (in assets sold and in revenue generated) between 01/01/2016 and 12/31/2016. The top two charts are just copies of the bottom charts to help make clear what I'm trying to do. I'd like the top two charts to contain data from the previous period. In this case, 01/01/2015 through 12/31/2015.

The report is grouped first by sales person and then by transaction date (from which the month is derived). The bottom two charts are accurate and, if I wasn't trying to include the previous period's data, the report would be done.

I've tried generating the top two charts in a sub-report but when I do, the top charts for all sales persons are generated for each set of bottom charts. I'm not sure how to accomplish the result I'm trying to achieve; one page for each sales person with the current period and the previous period displayed on the same page. Any guidance you can provide is appreciated.

RE: Previous Period Chart

I think you just need to link the subreport to the main report on the salesperson field.


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close