How to prevent emtpy fields in export in an easy an quick way?

[de.schmidd]

Hi there,

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.

Thanks
Daniel

[Sanjeeb2022]

Hi @de.schmidd - I believe this can be a feature request.

Hi @duncan @ErikG @Jesse - Can you please help on this?

Regards - Sanjeeb

[ErikG]

@de.schmidd what cells are empty? can you show the export?

[de.schmidd]

sure @ErikG , if you export the file in XLSX format the cell of the employee id is linked

[ErikG]

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.
BG

[Jesse]

Can you use a Table instead of a Pivot Table? Then there is no grouping behavior.

[de.schmidd]

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.
Thanks