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
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...
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...
Dear All,
I'm trying to get an output through Pivot table are as follows but unable to insert empty row/column in my pivot table.I don't want to disturb my database like insert additional column data sheet to get empty row/column in my output.
Also i need some idea to fix formula in pivot...
Hi Shakeel,
Thanks for the response but i'm facing problem to downloand your attachment.Please suggest me for downloand or send to zuresh82@yahoo.com
Suresh
Hi All,
I'm just trying to insert empty row and columns in Excel pivot table.Also some formula in the same pivot.
Eg:- I have generated P&L in PIvot and After GP Margin Row i want to insert blank row.I ws trying to add one column in my source data but i do not disturb my source data.
Also...