User defined consolidations in a slice
Posted: Tue Sep 12, 2017 3:24 pm
Hi
I am looking to find a way to create a temporary consolidation based on cells in Excel. I've seen that Active Forms have the functionality (where the TM1RPTROW formula references a hidden worksheet called {AR01} and the user can add elements to the list). However I've tried to do something similar in a slice but can't get it to work.
I need something that works similar to a rollup, but where I can define which elements go into that rollup from Excel.
Thanks in advance!
I am looking to find a way to create a temporary consolidation based on cells in Excel. I've seen that Active Forms have the functionality (where the TM1RPTROW formula references a hidden worksheet called {AR01} and the user can add elements to the list). However I've tried to do something similar in a slice but can't get it to work.
I need something that works similar to a rollup, but where I can define which elements go into that rollup from Excel.
Thanks in advance!