V
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
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