Pivot Table Problem

[pas926]

I have a pivot form in Excel 2000 that I would like to look like this

monday tuesday wednesday Tota
Sales 20.00 23.00 34.00 77.0
Tax 3.00 6.00 9.00 18.0

instead it looks like thi
monday tuesday wednesday Tota
Sales 1 1 1
Tax 1 1 1

I want the data field to display the info as it was entered by the user not give me a sum of the field, or a count of the field.. The data source is from an Access 2000 query. Help! Thanks in advance, Pau

 

[Peter Atherton]

Right-click on the desription and choose
Field Settings. Change these to Sum (they are probably set
to Count)

Regards
Peter

-----Original Message-----
I have a pivot form in Excel 2000 that I would like to look like this


monday tuesday wednesday Total
Sales 20.00 23.00 34.00 77.00
Tax 3.00 6.00 9.00 18.00

instead it looks like this
monday tuesday wednesday Total
Sales 1 1 1 3
Tax 1 1 1 3

I want the data field to display the info as it was

entered by the user not give me a sum of the field, or a
count of the field.. The data source is from an Access
2000 query. Help! Thanks in advance, Paul

 

[Colleyville Alan]

I have a pivot form in Excel 2000 that I would like to look like this


monday tuesday wednesday Total
Sales 20.00 23.00 34.00 77.00
Tax 3.00 6.00 9.00 18.00

instead it looks like this
monday tuesday wednesday Total
Sales 1 1 1 3
Tax 1 1 1 3

I want the data field to display the info as it was entered by the user

not give me a sum of the field, or a count of the field.. The data source is
from an Access 2000 query. Help! Thanks in advance, Paul

I am not sure if this is what you are after, it looks to me like the Pivot
Table functions do more than simply turn the stuff sideways. You can do
that in Excel by copying the data and then "Edit|PasteSpecial|Transpose"

If you want to use a pivot table, you could probably accomplish this by
using something unique for each day to "sum" by, so that you would have a
"sum of one" in your results table:


Day UniqueID Amt
Monday a 986
Tuesday a 559
Wednesday a 233
Monday b 523
Tuesday b 3354
Wednesday b 321


Sum of Amt Day
UniqueID Monday Tuesday Wednesday Grand Total
a 986 559 233 1778
b 523 3354 321 4198
Grand Total 1509 3913 554 5976