Insert Page Breaks

Hi,

I have a pivot table that in which I need to insert page breaks automatically.I have 3 columns in my pivot table-1. Item Descriptions 2. Stores 3. Revenue. And the Item Description column has a subtotal after every different item description. I have 1000 plus item descriptions. So therefore there are over 1000 item descriptions subtotal.

It does not matter where the page break is inserted, I just want to automatically insert page breaks that maximize page space and they must end with a subtotal of the item description.

Does anyone have any ideas I can do this?

Cheers!
pivot.JPG

@porucha vevrku

yes, maximize space means to have many subtotals on one page

Thanks!