How can i compare ordersalesamount & budgetamount by year ??

[Silambarasan1306]

Hi pls help me to compare ordersalesamount & budgetamount by year. If budget year don't have 2007 at that time value of budget amount could be '-'. but it retruns some other value.

[kaushiknsolanki]

Hi,

You will have to use concept of link table and link the years from both table.

Have a look at the link for more info.

Concatenate or Link Table?

Regards,

Kaushik Solanki

[satishkurra]

Use can also try the attached file. This will create a common date as Master Calendar and it should fix your problem

As you didn't provide the sample data, didn't get a chance to fix in your app...

Refer this...

This is from Rob Wunderlinch..

Thanks

Satish

[maxgro]

you have 2 tables or files with the same detail, year

you can join them, the result should be a table with Year, OrderSalesAmount, BudgetAmount

Fact:

load

     Calender_Year as Year,

     OrderSalesAmount

from  ......;

join (Fact)

load

     BudgetYear as Year,

     BudgetAmount

from ......;

[Silambarasan1306]

I want to compare both year. not to concatenate or link table. they both column not a table.