Forums
New posts
Articles
Product Reviews
Policies
FAQ
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Menu
Log in
Register
Install the app
Install
Forums
Apple Computing Products:
macOS - Apps and Programs
EXCEL Formula Help
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="fearlessfreap24" data-source="post: 984115" data-attributes="member: 9274"><p>after doing some research on the website that Sawday provided, i found that a Pivot Table worked best. the only problem is that you have to manually have to update the Pivot Table. What i mean by this is when i add information to the table that the Pivot Table is based off of the Pivot Table does not reflect the entry. i have to click inside the Pivot Table and hit a button to update the Pivot Table.I will try to find out how to update it automatically.</p><p></p><p>the first example is by category with the accounts subtotaled and a grand total by category.</p><p></p><p>the second example is by account with the categories subtotaled and an account grand total. if you drag the account header to the other side of category, it will rearrange the Pivot Table.</p><p></p><p>[ATTACH=full]12058[/ATTACH]</p><p></p><p>[ATTACH=full]12059[/ATTACH]</p></blockquote><p></p>
[QUOTE="fearlessfreap24, post: 984115, member: 9274"] after doing some research on the website that Sawday provided, i found that a Pivot Table worked best. the only problem is that you have to manually have to update the Pivot Table. What i mean by this is when i add information to the table that the Pivot Table is based off of the Pivot Table does not reflect the entry. i have to click inside the Pivot Table and hit a button to update the Pivot Table.I will try to find out how to update it automatically. the first example is by category with the accounts subtotaled and a grand total by category. the second example is by account with the categories subtotaled and an account grand total. if you drag the account header to the other side of category, it will rearrange the Pivot Table. [ATTACH=full]12058[/ATTACH] [ATTACH=full]12059[/ATTACH] [/QUOTE]
Verification
Post reply
Forums
Apple Computing Products:
macOS - Apps and Programs
EXCEL Formula Help
Top