About Neil_Doyle

Hey Fabien,   I can't really come up with an elegant solution but I have found a way to get it to work. Create the dummy list as you suggest Add an "All Versions" in the Versions in Settings which has formula A+B+C Create a Dummy Billings module which has both real versions and dummy versions in it Use your mapping module to put the numbers against the write dummy verions (hard to explain easier to see screenshot) The proceed with your line item selection and output module but the lookup also has a select:Versions.All Versions. Can't say I'd be delighted with this solution due to the extra Version for all and the additional space requirements of the Dummy Billings module. But it does get the job done if you can live with it. I think you could probably hide the All Versions from users.   Hopefully works or sparks some other thoughts. ... View more

Hey Charlie - do you really need to rank across time? You can do it with a bit of a workaround - creating a "month" list which you can rank across in a separate module and then bring it bank into your Time dimension module. Of course using any "month" list is not ideal as it needs updated manually if you expand your model timescale (but you could do this via a process if you wanted to!).   ... View more