• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Tables & Dates

wardja19

New Member
Hi, i am about to go through the process of looking at total values for some account balances so i can record their changes daily. This will require me entering 31 different data sets as i want to cover the whole month to eventually determine what percentage of the total monthly balance occurred in the first week for example.

I may want to expand this to apply to multiple months at a time and i was wondering if there is a way to setup a table correctly for this. My current plan is to just have the month on the left i.e. August then to the right of it the date until the end of the month. Is there a better way to record this? or a better way to eventually produce a report from this?
 
I'd just recommend flat table structure.

Date value in one column, category in another and then transaction amount in another.

This set up is conducive to later analysis and can be utilize Pivot Table for quick and easy summary.
 
Back
Top