Hello, I have the following data: Name/Formula/Format/Notes Transaction # /CODE(ITEM(# Transactions))/Text/(# Transactions is the numbered list I created with Properties of Account (Text Format), Cost Center (Text Format), Cost Pool (Text Format), Amount (Number Format), Version (Text Format), Period Text Format) Cost Center/No Formula/Text/ (I have a hierarchy set up for this) Account Code/No Formula/Text/ (I have a hierarchy set up for this) Cost Pool/No Formula/Text/ (I have a hierarchy set up for this) Year and Month/No Formula/Text/ (2 years by month) Scenario/No Formula/Text/ (i.e. Budget/Actuals) Amount/No Formula/Number Amount I have managed to import to a module via a numbered list by first importing the same data into a numbered list then using the numbered list as dimension and the other fields as line items. I am not sure this is the best approach as I will need to aggregate the data for calculations etc. Any advice on best practice? The data won't import using the other dimensions as there are multiple instances of cost center/accounts/in the data. Much appreciated for any advice you can provide.
... View more