RE: $$Excel-Macros$$ Addition of Formula in Pivot

2012-05-18 Thread Amit Desai (MERU)
roups.com> [mailto:excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>] On Behalf Of Aindril De Sent: 18 May 2012 10:28 To: excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com> Subject: Re: $$Excel-Macros$$ Addition of Formula in Pivot Hi Amit, Can y

RE: $$Excel-Macros$$ Addition of Formula in Pivot

2012-05-17 Thread Amit Desai (MERU)
FYI, please find attached sample sheet... Best Regards, Amit From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Aindril De Sent: 18 May 2012 10:28 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Addition of Formula in Pivot Hi Amit, Can you

Re: $$Excel-Macros$$ Addition of Formula in Pivot

2012-05-17 Thread Aindril De
Hi Amit, Can you send a sample dataset? Regards, Andy On Fri, May 18, 2012 at 10:22 AM, Amit Desai (MERU) wrote: > Please help... > > ** ** > > I have tried adding formula in Pivot but getting an error “#DIV/0! . > > ** ** > > I want Avg cost per Visit. There is a column for cost(colu

$$Excel-Macros$$ Addition of Formula in Pivot

2012-05-17 Thread Amit Desai (MERU)
Please help... I have tried adding formula in Pivot but getting an error "#DIV/0! . I want Avg cost per Visit. There is a column for cost(column head "A")in of each cab getting repaired & also cab registration number (column head "B")is maintained. Best Regards, Amit ___