currently some cells are empty if you are exporting them.
Is there any setting to prevent emtpy cells?
My current workaround is that I am adding fields in “rows” above the field with empty cells and set them to invisible.
I guess there is an easier solution?
I am looking forward to hear your insights.
Hi @de.schmidd - I believe this can be a feature request.
Hi @duncan @ErikG @Jesse - Can you please help on this?
Regards - Sanjeeb
@de.schmidd what cells are empty? can you show the export?
sure @ErikG , if you export the file in XLSX format the cell of the employee id is linked
Hi @de.schmidd ,
yeah those are “empty”. It’s an pivot table “feature” because it is grouped. For the visual it wouldnt make sense to repeat the values.
Can you use a Table instead of a Pivot Table? Then there is no grouping behavior.
unfortunately not but I found another way to handle this issue.
I can export the data of the pivot table in csv and then import it in excel. That works for me.