Pivot Table Insert new row column and % 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/s/njww5h05bpq0iy8/P%26L%20Formatting%20fof%202013-14.xlsx?m


Please advise me with your solutions.


Thanks


Suresh

 

[bobhc]

Good day Suresh


You will find it a lot easier to do this in your data sheet and then refresh the pivot table.

You have a lot of "Dummy" columns which do nothing but clutter up the pivot table and make hard to navigate the data and the pivot.


If you turned your data sheet into a table you would be able to filter "on the fly" for reports and to narrow down data search

 

[zuresh82]

Hi


Thanks....but I'm not understand what you are saying.


I will not have only this much data.This is a sample data only.Probably my data will 20 times than the sample data.


If you can workout and provide the sample file this will much helpful.


Suresh