what is the confusion here? just join with a common dimension and bring the results.
I think that is exactly the point in question...
Hi Aj ,
Thanks for reply but the confusion is
Budget data Actual data
How i pivot it .if i take the both measures it will append to the existing not reside on other column
I need to make this as separate but data is not present in one column .
below is my data structure and above is how i need to display
As_of_date sid measure1 measure 2 measure 3......
As_of_date sid measure 1 measure 2 measure 3.....