I am working on a materials planning chart - table, I have as dimension 'Material ID', then I have a row dimension 'Stockroom' which will have data only for the inventory expression, I have an expression for sales but I want only one column because it is not link to the stockrooms it will have numbers for each material ID but all the stockroom columns will be zero.
This is what I want:
Stockroom Stock#1 Stock#2 Stock#3
Material ID Inventory Inventory Inventory Sales-Lbs
Item1 45 10 13 10
Item 2 12 0 5 9
Item 3 0 0 0 23
Item 4 14 0 1 8
This is what I am getting:
Stockroom Stock#1 Stock#2 Stock#3 -
Material ID Inventory Sales-Lbs Inventory Sales Inventory Sales-Lbs Inventory Sales-LBS
Item1 45 0 10 0 13 0 0 10
Item 2 12 0 0 0 5 0 0 9
Item 3 0 0 0 0 0 0 0 23
Item 4 14 0 0 0 1 0 0 8
Stockroom is a dimension which I want to apply only to inventory.
