Calculating ratio from aggregation of two pivot tables

[jonathan_phj]

Hi all,

I currently have a scenario where I have stock issue data and inventory data in two separate pivot tables. Performing some aggregation of data allows me to obtain the stock issue costs as well as the net book value for the individual cost centers in each table like so.

The issue lies with combining these two aggregated values into a combined table in order to obtain the stock turnover ratio.

As there is no form of direct association between the issue and inventory data due to the nature of the source data. (Inventory data for the NBV comes in the form of a report listing down the material line items in stock at the end of every month, while issue data appears as line items whenever a material from stock is issued out)

Is there any way that will allow me to create this combined table essentially by simply doing a division of the aggregated values of the issue costs table over the net book value table for each of the rows and columns?

Thank you!

[chrismarlow]

Hi,

I don't think you are going to neatly get away from letting the data associate where it can through the Iss_CC_Group/Iss_CC and CC_Group/CC fields, have you tried that & did other things not work?

You could draw out the unique values into a table that links the cost and NBV table ... but that would be just neater modelling rather than strictly necessary.

Cheers,

Chris.