Re: $$Excel-Macros$$ Insertion of calculation column in Pivot

2014-11-11 Thread Tarun Verma
Thanks Vab, your instruction working superb but still there is miss match fill is attached with higlighting concern in red color. Done % for grand total is 217%. Thanks for you help Regards, On 11/11/14, Vaibhav Joshi wrote: > Select cell B4 then try this sequence.. > > + > *I did not do

Re: $$Excel-Macros$$ Insertion of calculation column in Pivot

2014-11-11 Thread Vaibhav Joshi
Select cell B4 then try this sequence.. + *I did not do this for you. God is here working through me for you.* On Tue, Nov 11, 2014 at 6:32 PM, Tarun Verma wrote: > Thanks Vab for your prompt revert and i tried the same but getting > error in doing same. > Error snapshot has been attached.

Re: $$Excel-Macros$$ Insertion of calculation column in Pivot

2014-11-09 Thread Vaibhav Joshi
Check this... You need to select Pvt Tbl Tools, Options, Formulas & then Calculated Item... Cheers!! + *I did not do this for you. God is here working through me for you.* On Sat, Nov 8, 2014 at 1:26 PM, Tarun Verma wrote: > Hi Team, > > Today i am tucked in a problem related to pivot. I

$$Excel-Macros$$ Insertion of calculation column in Pivot

2014-11-07 Thread Tarun Verma
Hi Team, Today i am tucked in a problem related to pivot. I have a pivot table in which i have some calculation outside of pivot and thats the only porblem. That calculation should be part of pivot table only not a outside calculations. Hope it is clear please revert if my problem in not underst