Link Budget Table.

[ch_riadh]

hello guys,

I have

-Sales table.

     Fields:

          Vehicle_Model

          MonthYear ' invoiceDate '

          Sale_Amount

-Budget table:

     Fields:

          Vehicle_Model

          MonthYear ' BudgetDate'

          Budget_Amount

I want to compare the Budget & Sale Amount (Line Chart)

What i did:

Create a Key ( Vehicle_Model &'-'& MonthYear ) , it is look good, but the Budget value are not matching.

Solution : when i use only one field (Model or MonthYear) to link the 2 table, the Value become Correct.

But i need Both Dimension.

Thanks      

[sunny_talwar]

Can you share the application or the script you are currently using?

[#3]

I suggest you should concatenate those 2 tables & have 2 different types as a column for Sales & Budget

With that you can have 1 MonthYear column that you can use to generate calendar

Sales table.

     Fields:

          Vehicle_Model

          MonthYear

          Sale_Amount As Amount

          'Sales' As Type

//concatenate -Budget table:

     Fields:

          Vehicle_Model

          MonthYear

          Budget_Amount As Amount

          'Budget' As Type

[Digvijay_Singh]

You may try joining them in case your both sales and budget are at same level of granularity, i.e. MonthYear. Against same month year and Vehicle_Model you will have sales and budget in the same row. But if Budget is at year level and sales at month level then it would be better to concatenate and create record type 'Sales' or 'Budget' to identify them in the same table.

[sujeetsingh]

Can you please come in more words that what statstics you want to show in your application.