pvt table field settings!

  • Thread starter Thread starter via135
  • Start date Start date
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
 
Back
Top