AnsweredAssumed Answered

Summary Table Issue

Question asked by Lantonicus on Mar 11, 2012
Latest reply on Mar 11, 2012 by davidanders

Title

Summary Table Issue

Post

Dear All,

I am a little bit lost and before I take further steps, I want to make sure that I am doing the right thing.

I am developing a system that records my daily expenses (cash, credit card, debit card, Lending, Borrowing, Income, etc)

currently, I have one big table that has all the records ( based on their daily occurences) 

I created different  layouts related to this table that shows my daily cash expenses, credit card expenses and etc. I have summary based on daily basis, monthly bases and year basis. This is great!

But

I am now trying to create a layout ( or a table, this is what I am confused about) that

summurized as follows

year 2009  Total Cash  , Total Credit Card, Total Debit card , Total of all

year 2010  Total Cash  , Total Credit Card, Total Debit card , Total of all

year 2011  Total Cash  , Total Credit Card, Total Debit card , Total of all

year 2012  Total Cash  , Total Credit Card, Total Debit card , Total of all

 

Same for Monthly Totals as well

Year 2010

January,  Total Cash  , Total Credit Card, Total Debit card , Total of all

Ferbuary Total Cash  , Total Credit Card, Total Debit card , Total of all

.

.

Year 2011

Jan   ....

Feb ...

 

I dont want to see daily records

I want to summurize interms of years and months

 

Does any body  has any suggestion what I should do?

Do I need to create a new table that gets and totals the values in itself

or can I use my current single table that has all the daily records in it?

 

Thank you all in advance.

 

Orkun

.

 

 

 

 

Outcomes