pvt table field settings!

[via135]

hi!

i am receiving data every day from 10 different places as under.!

for example:

DATE 11.01.2009
PLACE "A"
TOTAL NUMBER OF RECEIPTS 10
TOTAL OF RECEIPTS AMOUNT 1000

DATE 11.01.2009
PLACE "B"
TOTAL NUMBER OF RECEIPTS 50
TOTAL OF RECEIPTS AMOUNT 1500

DATE 11.02.2009
PLACE "A"
TOTAL NUMBER OF RECEIPTS 15
TOTAL OF RECEIPTS AMOUNT 1000

DATE 11.03.2009
PLACE "C"
TOTAL NUMBER OF RECEIPTS 10
TOTAL OF RECEIPTS AMOUNT 1000

-likewise i'm receiving daily data from all the 10 places..!

what i want is a pivot table report on any day
for date wise / place wise sum of number of receipts
along with the total receipt amount
for all the 10 places.!

how can i set the row / col / data fields for inputting the data
so that i can get the table as mentioned above.?

any hlp.?

-via 135

 

[etaf]

You have for fields can you set up the data entry as follows

Code:

 

[Herbert Seidenberg]

Excel 2007 PivotTable
Trim, rearrange and pivot.
http://c0444202.cdn.cloudfiles.rackspacecloud.com/11_22_09.xlsm