please help in data modeling

[#1]

Hi ,

I have attached a sample app.

i have two tables and both are having  conssioners and sale .

i want to show some of sale conssioners wise and total sale of  the month,

table two having two types of sale so i want both of the sales

i want to link this to calender as you can see in the app.

format of date and year are defined in calender.

[sasikanth]

hi

PFA