Peter, Our group is getting access to our VA 7.1 test environment this afternoon and I will ensure that this same functionality exists in the latest version. I will be in touch! -shawn ... View more

Peter, I use the External Link functionality within VA to link a crosstab to an external website that accepts parameters being passed to it (which may be what you are looking for). For example, in my cross tab I have a Sales Business Unit, Account Name, and Sales Opportunity Name then the Sales Opportunity ID. When I drill down all the way to the Sales Opportunity ID, I am able to double click on any of the metrics in the crosstab and am hyperlinked to our SalesForce Automation tool which accepts the Opportunity ID as a parameter into the URL, being passed to it from VA, and I can am able to see the Queried results perfectly. I am using VA 6.4 to perform this and use an External Link interaction to hyperlink to a web page. -shawn ... View more

You can also union the total at the bottom of the SQL: proc sql;     create table SUM_BY_STATE as     SELECT            STATE            ,sum(MEMBER_COUNT) as TOT_MBR_COUNT                  ,sum(MEMBER_SPEND) as TOT_MBR_SPEND     FROM RECORD1     GROUP BY STATE union     SELECT            'Grand Total' as State,            ,sum(MEMBER_COUNT) as TOT_MBR_COUNT                  ,sum(MEMBER_SPEND) as TOT_MBR_SPEND     FROM RECORD1 quit; ... View more

To paraphrase Michelle even more...Think of a dashboard as something high level to give quick answers (i.e. reports for Executives), and the reports provide the granular details, which support the Dashboards, and would be used by marketers, in my world, who may work with the data on a more frequent basis. Dashboard = Summary Reports = Details ... View more