Summing data in a ragged hierarchy (just for reporting purposes)
Is there a way to sum data in a ragged hierarchy that will only be used for reporting?
My source module is a Data Load module with all my GL transactions. The target module will be an output report dimensioned by a ragged hierarchy. I can get the data to sum on the lowest levels of the hierarchy but Anaplan does not seem to like summing on the upper level accounts that also have data.
I saw the training by Rob Marshall, Hub Model Hierarchy Management (305), but am wondering if there's another way since this is just for reporting and not actual planning.