View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
via135 via135 is offline
external usenet poster
 
Posts: 94
Default pivot table field structure!

hi!

i want a pivot table for the following data


DATE
PLACE
RECEIPT NO
RECEIPT AMOUNT

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

i want a pivot table report for date wise receipt no along with the
receipt amount
for all the 10 places.!

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

-via 135