prob with pivot

[#1]

Hi all,

i have a prob wit two tables in a Pivot Table:

with the first table i create a Pivot table with differnet dimensions. all is fine

the last Dimension is the coscenter

like this

first dim| secondim| costcenter 1745

                                                  1746   

                                                   1747

in the first table trhe last value ist for the costcenter.

the second table contains values for only costcenter 1747

how can i bring These values in my Pivot. second Problem are the datefields.

first table i have year field and month field

second table only a det filed

i have to select by the periods of a year

last Problem is a different financial year.

can someone help me?

[giakoum]

showing only 1747 must have to do with your data model. Could you post a sample app?

[chrismarlow]

I think you need to concatenate your data into 1 fact table, fixing odd fields as you go (so creating a full date where you only have month/year assuming either first or last day of the month). Difficult to say anything further without a sample app as Ioannis suggests.