Pivot Table Empty Row % formula

[zuresh82]

Hi


I'm trying to fix the Pivot Table for Profit & Loss Statement but there is issue to insert empty row & column after certain types of expenses.


Also I need to insert formula to give all the Expenses as % on Sales.


Please find the attached sample file in below link.


https://www.dropbox.com/home?upload=1#!/home


Please advise me with your solutions.


Thanks


Suresh

 

[zuresh82]

Sorry use the below link...


https://www.dropbox.com/s/njww5h05bpq0iy8/P%26L%20Formatting%20fof%202013-14.xlsx?m