K
KLP
I have a spreadsheet in Excel of a company's financial statement. The first
column is cells that comprise the asset, liability and income, expense
accounts, e.g., cash, accounts receivable, notes payable, accounts payable,
etc. The next column is the amount for that account, the 3rd column is a
percentage of that cell's value divided by total assets. Typically there are
3 years of information - 6 columns plus the initial column. Below is is an
idea of how it would look in Excel.
Year 1
Account Amount %
Cash 100,000 5.1%
A/R 125,000 6.2%
etc ...
Tot. Assets 575,000 100.0%
Is it possible to create this in Access using a pivot table? I have a table
to collect the statement detail for each year.
column is cells that comprise the asset, liability and income, expense
accounts, e.g., cash, accounts receivable, notes payable, accounts payable,
etc. The next column is the amount for that account, the 3rd column is a
percentage of that cell's value divided by total assets. Typically there are
3 years of information - 6 columns plus the initial column. Below is is an
idea of how it would look in Excel.
Year 1
Account Amount %
Cash 100,000 5.1%
A/R 125,000 6.2%
etc ...
Tot. Assets 575,000 100.0%
Is it possible to create this in Access using a pivot table? I have a table
to collect the statement detail for each year.