Hi, I just built something that might help you, if I understand the problem well? First build a small module for giving quarters a boolean: These are the formulas: Then the module with the data: In this case taken from line items --> so created LIS and pulled all data in via COLLECT() The formulas are set as follows: IF Offset Settings Quarters.Show Quarter? THEN Final Value - 'Final Value Q-1' ELSE IF Offset Settings Quarters.Show month? THEN Final Value - 'Final Value M-1' ELSE Final Value - 'Final Value Y-1' --> with summary FORMULA Which results in fact tha Q in compare column show the difference of the current Q compared to teh previous Q and not just the sum of the months, same for Years. Kind regards, Maud
... View more
Sorry for the late reply, You could use the following option: make sure the lists(hierarchies) that you want to keep are NOT tagged as production data, tag other lists as production data, create a revision tag and and then create a model based on the revision tag, it will contain all hierarchies(except the production hierarchies) and formulas, but no production lists or data. It will only make the model smaller if the largest lists can be tagged as production. Another option to reduce the space is deleting versions and reducing time settings (can be used in combination with the revision model).
... View more