In this video I'll show you how to create a drillthrough. This allow you to select a data point on a bar chart and then open a further report to explore the detailed transactions which make up the particular value.
It's a great bit of functionality that I use on most of my dashboards.