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?
Go to Solution.
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)
View solution in original post
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