Making graphs with variable (1 Viewer)

Dear all,

I am currently working on making an automatic report for my boss in which I must see whether new products really sell. So I have already done some work and I have figured out that I can make a graph like in the attachment. It is done by creating the graph with sales in the y axis, period in the x-axis and with the introduction date grouped by Year.

My boss was wondering if it is possible to make some grouping, where that you can set your own filter date, so making such figures with data points before and after a certain date filtered. I have searched and searched, but I cannot find it... The ultimate goal is that it can read the filter date from the report and can set it automatically.

Thank you for your time!

I recently saw a Mr. Excel video on pivot tables. It had a very good segment of data slicing. Track that video down and it might give you some ideas.

start with this site: http://myexcelonline.com/pivot-table-course.php

Hi IIkhoutx,

Thanks for your information, I will check it out. I have encountered that Access2013 has discontinued some features that I really need for this problem, so I must find another way. (Maybe via Excel) Thank you for your time.

Bob