pivot table blank rows

[plasticc]

hello, I'm trying to insert a blank row after each sub-total in my pivot table however, excel is instead inserting a blank row after each row/entry. How can i fix that?

 

[GraH]

I guess, this should work fine. Select the field (where you have subtotal) and in the field settings check insert blank line after each item label.
And if this is what you did, maybe you can share a sample data set and a screenshot of your pivot lay-out.

 

[plasticc]

Select the field (where you have subtotal) and in the field settings check insert blank line after each item label.

View attachment 108138

i don't have this option on mac

 

[GraH]

I do not have a mac. Hopefully someone else can help you.