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 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...