Total Column in Dashboard

Ben,
It can't be done until 8.0 in the dashboard.
That being said, I use queries to automatically export to web pages (.asp)
and then can display totals there, or even better I pull this web export
into excel via a query (set to refresh on open) and us a pivot table to
analyze the results. The web query can be set to export every so many
minutes by your schedule making it close to real time if desired.
There is always the ODBC option as well, but until 8.0, that's the best I
can offer.
Good luck,
Aaron Hoyt
Vantage Plastics


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Ben Belzer
Sent: Wednesday, January 11, 2006 2:17 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Total Column in Dashboard


Has anyone found a way to have a Total column in a dashboard query?



Even if I could have a column that showed accumulated totals ie:



A1

A1+A2

A1+A2+A3



I'm trying to show pieces shipped during the day, and I'd like the
dashboard to add up the numbers.



Thanks in advance!





Ben Belzer
IT Manager

TCI Precision Metals
800.234.5613.W
310.323.1255.F
bbelzer@... <mailto:bbelzer@...>
www.tciprecision.com <http://www.tciprecision.com/>







[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
Has anyone found a way to have a Total column in a dashboard query?



Even if I could have a column that showed accumulated totals ie:



A1

A1+A2

A1+A2+A3



I'm trying to show pieces shipped during the day, and I'd like the
dashboard to add up the numbers.



Thanks in advance!





Ben Belzer
IT Manager

TCI Precision Metals
800.234.5613.W
310.323.1255.F
bbelzer@... <mailto:bbelzer@...>
www.tciprecision.com <http://www.tciprecision.com/>







[Non-text portions of this message have been removed]