Want numbers not sums in pivot

[vjp2.at]

I have a database (dbf) which I bring into excel
It has columns u v w x y z
I want a table of z with x changing across and v changing down
I got a pivot table, but it sums (it gives me the same value of z under any given column of x)
(z is returns, x is date, v is stock-tickers)

Is it possible to get it to just report each value and not sum?


(pls cc email)

- = -
Vasos-Peter John Panagiotopoulos II, Columbia'81+, Bio$trategist
http://ourworld.compuserve.com/homepages/vjp2/vasos.htm
---{Nothing herein constitutes advice. Everything fully disclaimed.}---

 

[vjp2.at]

It is creating a query as

TRANSFORM Avg([151917608].EWRETD) AS AvgOfEWRETD
SELECT [151917608].TICKER
FROM 151917608
GROUP BY [151917608].TICKER
PIVOT [151917608].DATE;

but I want

TRANSFORM 1.0([151917608].EWRETD) AS SelfOfEWRETD
SELECT [151917608].TICKER
FROM 151917608
GROUP BY [151917608].TICKER
PIVOT [151917608].DATE;

If I try SELECT EWRETD GROUP BY TICKER PIVOT DATE it gets really mad.
But I'M MAD because that's what I want.

Is this "TRANSFORM/PIVOT" really SQL or is it just by NecroSmurf?

I learned SQL on IBM/MVS/DB2 in 1986 and it wuddn't there.

In <[email protected]> by (e-mail address removed)
on Wed, 24 Mar 2004 03:04:21 +0000 (UTC) we perused:

*+-I have a database (dbf) which I bring into excel
*+-It has columns u v w x y z
*+-I want a table of z with x changing across and v changing down
*+-I got a pivot table, but it sums (it gives me the same value of z under any given column of x)
*+-(z is returns, x is date, v is stock-tickers)

*+-Is it possible to get it to just report each value and not sum?


*+-(pls cc email)

*+- - = -
*+- Vasos-Peter John Panagiotopoulos II, Columbia'81+, Bio$trategist
*+- http://ourworld.compuserve.com/homepages/vjp2/vasos.htm
*+- ---{Nothing herein constitutes advice. Everything fully disclaimed.}---