User Filters

I have created a chart that shows the TOP FIVE KEYWORDS for a SEM campaign by click. No problem to do this, and the chart looks great. However, other fields in the database include "Campaign" and "Ad Group" and I would like to allow the user to select the "campaign" and "ad group" to see the TOP FIVE KEYWORDS by each combination.

My problem is that ZOHO first generates the report of the TOP FIVE KEYWORDS for the entire account and then the user can only filter THAT data. Rather than the user filter regenerating the TOP FIVE KEYWORDS based on that filter combination.

Essentially, the report is generating out of order. I want the user to be able to select "Campaign" then have the "Ad Group" user filter show the ad groups within the campaign selected, then I want the chart to show me the TOP FIVE KEYWORDS for that Ad Group.

I hope that makes sense. Is there a way to do that?

Jamie