W
William Hite
Where is it documented?
Is it the solution I seek?
Data from a query looks like this
cn type sp nt
BAD00001 R fd 50
BAD00001 I fd 50
BAF00002 I kj 600
BAF00002 I kj 600
BAF00002 R kj 400
BAF00002 R kj 297
And I can easily generate a pivot table report looking like
type
I R
sp tot nt tot nt
--------------------------------
fd 50 50
kj 1200 697
I now want, *in my pivot table*, to add a calculated field (or total?) which
gives me a new column showing R as a percentage of I thus
type
I R P
sp tot nt tot nt nt%
--------------------------------------------
fd 50 50 100%
kj 1200 697 58%
(Yes, it is sales data - receipts against invoices by salesperson and
contract)
I cannot find any detailed explanation of how you add items to an Access
pivot table (can it be done?) nor any help with parts of the field properties
window - what do all the lines in the Captions/advanced information list
mean? where are they documented? how do you use them?
Help! my head is spinning...
Is it the solution I seek?
Data from a query looks like this
cn type sp nt
BAD00001 R fd 50
BAD00001 I fd 50
BAF00002 I kj 600
BAF00002 I kj 600
BAF00002 R kj 400
BAF00002 R kj 297
And I can easily generate a pivot table report looking like
type
I R
sp tot nt tot nt
--------------------------------
fd 50 50
kj 1200 697
I now want, *in my pivot table*, to add a calculated field (or total?) which
gives me a new column showing R as a percentage of I thus
type
I R P
sp tot nt tot nt nt%
--------------------------------------------
fd 50 50 100%
kj 1200 697 58%
(Yes, it is sales data - receipts against invoices by salesperson and
contract)
I cannot find any detailed explanation of how you add items to an Access
pivot table (can it be done?) nor any help with parts of the field properties
window - what do all the lines in the Captions/advanced information list
mean? where are they documented? how do you use them?
Help! my head is spinning...