Repeat dimension members in export to excel
When I Export to Excel – I want to always repeat dimension members on all rows – can this be set up as default?
0
When I Export to Excel – I want to always repeat dimension members on all rows – can this be set up as default?
Comments
In files, at the top, press the little arrow next to Excel and choose "Custome Export" (Mine is in another language, so I am not sure it is the exact text).Toggle the "Repeat dimensions mombers on all rows" and at the bottom toggle "Save as default".
That should do it.
Thanks for the tip, Jesper - It works in the Windows client..
But is it possible to do so in the anywhere client? As far as I can see, I don't even have the option manually to choose custome export of a crosstable. So if I can't set is as default, is there a way to select "repeat dimension members on all rows" when I right click on the table and want to export it to excel?
I haven't found the way to do it, if it is possible, unfortunately.
I have got this tip and screenshot from Kolding kommune:
But unfortunately we use the embedded version, so I haven't got this menu bar in the top of the analysis :-/
Is there still no answer to this question? I am also looking for a solution.
Hello Milk,
I learned a workaround and that is to copy the export folder containing the "TableData file" to a specific user's settings folder. See the screenshot below. You will find this folder and the file in a folder of a user who has activated the repeat setting.
I hope this helps.
Please sign in to leave a comment.