Splitting the data into 12 months

[Aspiring_Developer]

Hi ,

I have the  below scenario:-

Table1:

Crosstable(Months, Value,2)Load

Budget,

Actual as Flag,

April,

May,

Jun,

Jul,

Aug,

Sep,

Oct,

Nov,

Dec,

Jan,

Feb,

Mar

From ....

 I have "Budget" and suppose it has  a value say 25000 and it i have to divide it by 12 and show the each value with respect to months. But i do not have any month specific values for "Budget".

The above Apr to Marc has the values for "Actuals" but i don't have any months for "Budget". 

How should i divide the value of budget by 12 and show each value for months ?

Budget  April, May, Jun,Jul,Aug,Sep,Oct,Nov,Dec,Jan,Feb,Mar

25000, values1, value2, value3(25000/12)

Note: Both the values of Actuals (monthwise) and Budget are in the same table

[Kashyap_R]

Hi 

Please go through the attachment I have distributed sample budget across all months

Hope this helps

Thanks

[Aspiring_Developer]

Thanks for the above solution but i want to display the data like this:-

But i have to show the data like this:-

TABLE 1:

Object No,

Country

Element

Project Type

Table 2:

Crosstable(Months, Values, 7)load

Object No,

Ledger No

....

'Actual' as Flag,

Budget,

April,

...

..

Mar

Master calednar:

Date // linked with table 2

Budget:

Load *,

Budget

Join

Load * Inline[

Jan,

Feb....

..

Dec]

Final:

Load *,

Num(Budget/12) as Buget

Resident Budget

Drop table Budget

I want to create  a link between Table1 and Budget on the "Object No". But when i ma trying, getting error "Ciruclar reference". How should i create a link between these two table so that i can fetch the value of budget with respect to "ObjectNo". Please help !