View Single Post
fearlessfreap24

 
fearlessfreap24's Avatar
 
Member Since: Feb 09, 2005
Location: Near San Diego, CA
Posts: 2,339
fearlessfreap24 is just really nicefearlessfreap24 is just really nicefearlessfreap24 is just really nicefearlessfreap24 is just really nice
Mac Specs: MacBook Pro 13" | MacBook Pro 13" | Mac Mini 2GHz C2D

fearlessfreap24 is offline
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.
Attached Images
File Type: png Picture 1.png (28.6 KB, 4 views)
File Type: png Picture 2.png (25.4 KB, 3 views)

QUOTE Thanks