Thanks for getting back to me. 1- The Line items are line items (The normal P/L items) 2- I put the rows as a subset (Ext RI, Net, Gross etc) 3- Other dimesions are time, and entities. ( I hope to link the gross to another module then use the other columns to build formulas off the Gross figures.) 4. So the Gross is the total (which I am taking from another module) then the other ones I am using ratios to multiply the gross to break it down and others just to subtract. My issue when doing this is the formula will link all items in gross to revenue rather then to the matching name. Hopefully I am making myself clear. Apologies if I am not.
... View more