Pivot Table hide detail Option suppression

[stickandrock]

I have a pivot table view of a query.

I only have 3 fields in the query (Name, Date and Amount)

There is only one amount for each Name and Date combination.

within my pivot table it gives me the -/+ option for the each row and
column. this is a pointless option since I only have one detail element per
column and row combination.

It adds additional noise to the chart when it not neccesary to show all the
-/+ options.

Is there a way suppress that option from the view?

Any and all input would be greatly appreciated.....

 

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Instead of using a Pivot table you could use a cross-tab query - same
results, different display. Example:

TRANSFORM SUM(Amount) As theValue
SELECT Name, SUM(Amount) As Total
FROM table_name
GROUP BY Name
PIVOT [Date]

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBScLHSIechKqOuFEgEQI0NQCgioLag5VZ10VlTONZVxZhsKEaCb8An0wA
Dkni8+/JVfQ+b1BZ8ZxQsYBS
=/6bf
-----END PGP SIGNATURE-----