Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

pvt table field settings!

1 view
Skip to first unread message

via135

unread,
Nov 22, 2009, 5:00:57 AM11/22/09
to
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

unread,
Nov 22, 2009, 6:42:47 AM11/22/09
to

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

Code:
--------------------

ColumnA ColumnB ColumnC ColumnD
DATE PLACE ReceiptNumber ReceiptValue
--------------------


It would then be quite easy to create a PVT


--
etaf
------------------------------------------------------------------------
etaf's Profile: http://www.thecodecage.com/forumz/member.php?userid=1223
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=156263

[url="http://www.thecodecage.com"]Microsoft Office Help[/url]

Herbert Seidenberg

unread,
Nov 22, 2009, 7:14:11 PM11/22/09
to
Excel 2007 PivotTable
Trim, rearrange and pivot.
http://c0444202.cdn.cloudfiles.rackspacecloud.com/11_22_09.xlsm

0 new messages