• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pivot Table

zuresh82

New Member
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 All the expenses need to give % on Sales in right sight of the values in same P&L table.


Please advise to me.


Suresh Kumar
 
Hi Suresh!


i would like to suggest you to use Pivot in Back Up, while in new sheet you should manage profit and loss, it is also automatic as all cells are linked with Pivot table but are more dynamic, can change according to your desire.


Further if you share you work book, not exact data may be sample we can suggest you better


below is the link "How to Post Sample Work Book"


http://chandoo.org/forums/topic/posting-a-sample-workbook


Regards!

Shakeel
 
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, zuresh82!

That's not a link for download anything, it's just one of the green sticky topics at this forums main page, which I strongly suggest you to go thru if you haven't done it yet.

Regards!
 
Back
Top