Hi,
I have a module that is dimensioned by product. I would like to export this module for each product in a single excel workbook, with each product on a new tab. Is this possible?
Thanks
You can use the multi-sheet connection functionality in the Excel Add-in (it was released in 3.4 and is also available in 4.0)
@CommunityMember113484
Sadly I do not think this is possible via the UX or modelling environment.
However, I would explore using the add ins for Excel where you can create a dynamic link into your model and have the Excel update directly within Excel.
@CommunityMember113484 While exporting, Pivot the product dimension into Pages. Now you can use Export>Grid Layout option and select "All Pages" radio button to export all the products data in single workbook with each product in separate tabs.
Hope this helps
AB
Hi - can't access support portal having already registered. Receive the following error message - is this an issue with Anaplan or our internal IT?
Can someone help me i am unable to login anaplan portal using my credentials
Dear Hive Mind, Do we have a way to get the history of a particular List Item, from its creation into a model up until its removal ? I am trying to chase when / how an item has been added into a model and how / when it would have been deleted and then recreated with the same code. Is there a pattern (manual or API) to get…
