Want to compare Current and historical values of same time period

[AshDil]

Hi,

I have main table and history table in sql for forecast sale values.

Beginning of July, I'll get values for July , aug, sep months in sql. After fortnight again values get updated for July,Aug,Sep.

Beginning of Aug month, I'll get values for Aug, sep,oct in sql. They update values for Aug, Sep and gives new values for Oct.

After fortnight again values get update for Aug, Sep, Oct.

Beginning of Sep month, I'll get values for Sep,Oct and Nov in sql. They update values for Sep,Oct and gives new values for Nov. After fortnight again values get update for  Sep, Oct, Nov. and So on.

When ever data gets updated in main table, all history values will be saved in history table in every instance. You can see how my data gets updated in reply.

Now I need to show comparison among historical 1, historical 2 , historical 3 and current values for months Sep, Oct,Nov.........

Please help me to do

Thanks,

AshDil.

[amitchandak]

@AshDil , Are you getting data in this format ?