I am having trouble limiting my drill through query for a single series pie chart. I have an ASP page which displays 6 charts. I am using classic ASP along with Fusion Charts ASP Class to display a pie chart and drill through on the data. I have filters at the top of my page which filter the results of all 6 charts.
I want to display one of the fields from the filters in the chart but allow the chart to drill through to additional data using all of the filters. Is there a way to drill through on multiple parameters without specifying them in the select statement?
Select Statement for chart:
select BV, ROUND(SUM(AMT)) amt
from KPI_BACKLOG_V
WHERE YEAR = 2013 and SITE = 'CIC'
group by BV
Drill Through and Chart display:
Call FC6.addDataFromDatabase(oRs6, "amt ", "BV","","N-Drilldown/Request.asp?period=##PERIOD_NAME##&segment=##SEGMENT##&site=##SITE##&BV=##BV##&BSV=##BSV##&Market=##STRAT_MKT##&Family=##STRAT_FAM##")